Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hoarsen” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

229 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hoarsen1036799(None) 
coarsen93210321coarsen
hoarse94411321hoarse_
hoarsens11306031hoarsens
hoarser10388391hoarser
coarse84813902coarse_
coarsens10348122coarsens
coarser93211202coarser
harden105718532h_arden
harken135116342h_arken
harshen1339282h_arshen
hausen9610382h_ausen
hearken14338032hearken
hearse94114282hearse_
hearsed113811422hearsed
hearses104414542hearses
hearten102411762hearten
hoarded12368342hoarded
hoarder11329232hoarder
hoarier104211742hoarier
hoars85925552hoars__
hoarsely1444372hoarsely
hoarsened1344052hoarsened
hoarsest1137132hoarsest
horse86132652ho_rse_
horsed105321082ho_rsed
horses94729352ho_rses
horsey125115402ho_rsey
hosen85623882ho__sen
oarsmen938092_oarsmen
sarsen6314232_sarsen
worsen95513872wo_rsen
ahorse9311513aho_rse_
arisen65316793__arisen
arpen74418043__arpen
arse46539273__arse_
arseno6318913__arseno
arses55733873__arses
arson55118833__arson
barmen105418543_barmen
barren85317623_barren
boarded113910503boarded
boarder103910323boarder
boardmen1344073boardmen
boars75229603boars__
boatmen1146913boatmen
boatsmen1245283boatsmen
boreen8314313bo_reen
bourse84414333bourse_
bourses94014303bourses
boursin938283boursin
careen84119493_careen
carmen104019353_carmen
carse74934333_carse_
carses85233653_carses
carven114716663_carven
chorten122811303cho_rten
chosen116014133cho__sen
coarsely1335533coarsely
coarsened1245143coarsened
coarsest1039163coarsest
corse75036183co_rse_
corses84433463co_rses
corset85636223co_rset
course85117783course_
coursed104113603coursed
courser94114803courser
courses94218893courses
darken114013443_darken
doormen1036753doormen
dorsel75315503do_rsel
dorser74819183do_rser
foramen12310533foramen
garden84215083_garden
gorhen1038903go_rhen
gorse65926813go_rse_
gorses74723293go_rses
haars85620473haars__
haen76229453h_a__en
hanse85722793h_anse_
hansel95214373h_ansel
hanses95022633h_anses
happen134812193h_appen
hapten115312983h_apten
hardens113815023h_ardens
harder105022403h_arder
hardset113415833h_ardset
hare76255733h_ar_e_
hared95742183h_ar_ed
hareem114312063h_areem
harem104924453h_ar_em
hares86255543h_ar_es
harked145422553h_arked
harkens144112863h_arkens
harmed125218843h_armed
harmer114719563h_armer
harmin113117403h_armin
harped124418403h_arped
harper115018403h_arper
harpin113614383h_arpin
harsh116418053h_ars_h
harshens1437603h_arshens
harsher13310363h_arsher
harslet10315653h_arslet
hassel95614213h_assel
hasten95718563h_asten
hausens1077633h_ausens
haven114718533h_a_ven
hawse116015123h_awse_
hawser125910843h_awser
hawses125113993h_awses
headmen13259513headmen
headset11312603headset
headsmen1465983headsmen
hearer94323653hear_er
hearkens15336693hearkens
hears86737373hears__
hearsay1335523hearsay
hearsing1239383hearsing
hearted113314033hearted
heartens113010153heartens
heathen133410893heathen
heaven123912603hea_ven
hirsel9138683h_irsel
hoagie102310013hoagie_
hoagies112811993hoagies
hoar76729163hoar___
hoard94918313hoar__d
hoarders12307433hoarders
hoarding13288643hoarding
hoards104912623hoar_ds
hoariest11312883hoariest
hoarily1338973hoarily
hoarseness1345313hoarseness
hoarsening1444403hoarsening
hoary114516763hoar__y
hoatzin1943943hoatzin
hoaxed17378873hoa_xed
hoaxer16348563hoa_xer
hoaxes163611693hoa_xes
hocused13167013hocused
hocuses121710433hocuses
hodden113811453ho_dden
hoers85724923hoers__
hoiden103612333ho_iden
hoise85224773ho_ise_
hoised105117433ho_ised
hoises94823683ho_ises
holden104113953ho_lden
holpen11299413ho_lpen
homosex1936133homosex
horas86333103horas__
horde94623053ho_rde_
horded115420483ho_rded
hordein1138753ho_rdein
hordes104921633ho_rdes
horn76735613ho_r__n
horned105718703ho_rned
hornet94926433ho_rnet
horrent10313553ho_rrent
horseman1346833ho_rseman
horsemen1347483ho_rsemen
horsier103013243ho_rsier
horsing113215583ho_rsing
horst85833513ho_rs_t
horste94817413ho_rste
horstes104516113ho_rstes
horsts95817513ho_rsts
horsy116318393ho_rs_y
hose76547243ho__se_
hosed95830983ho__sed
hosel86024823ho__sel
hoser811529763ho__ser
hoses85443183ho__ses
hosey116127023ho__sey
hours85422393hours__
house89131423ho_use_
housed105624103ho_used
housel95217053ho_usel
houser95322283ho_user
houses96032283ho_uses
hoyden13328933ho_yden
loosen66615963lo_osen
marse76231153_marse_
marses84827113_marses
marten84518263_marten
moorhen1236023moorhen
moreen8313343mo_reen
morgen9312203mo_rgen
morse76032703mo_rse_
morsel85815893mo_rsel
oaken95814383_oa_ken
oared65030653_oar_ed
oars46846033_oars__
oarsman937743_oarsman
oases55330983_oa_ses
oaten55222403_oa_ten
owsen84210193_o_wsen
parse75236993_parse_
parsec105914483_parsec
parsed96323893_parsed
parser84822373_parser
parses85534703_parses
parson83817903_parson
peasen84815963pea_sen
pocosen1146833pocosen
roared75015393roar_ed
roarer63914333roar_er
roars55622243roars__
sarsens7311393_sarsens
sharpen12389723sharpen
shorten103511413sho_rten
smarten9348863smarten
soared74324293soar_ed
soarer64522243soar_er
soars54732513soars__
sonarmen1045253sonarmen
sparse84516343sparse_
sparser94311483sparser
torse55833333to_rse_
torses64727953to_rses
torten65314353to_rten
warden104515513_warden
warren95012863_warren
worse86525263wo_rse_
worsens104610263wo_rsens
worser95117523wo_rser
worses95522953wo_rses
worset96726583wo_rset

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340272299.09314739.6
3Display Results2292290.0932462.4
 (SQL Overall)1786912299.59218629.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.