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 “hoarsest” 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.

151 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
hoarsest113713(None) 
coarsest1039161coarsest
hoariest11312881hoariest
hardest113118412h_ardest
harshest14310192h_arshest
harvest132112752h_arvest
hearses104414532hearses_
hoarse94411322hoarse__
hoarsely1444372hoarsely
hoarsen10367992hoarse_n
hoarsens11306032hoarsens
hoarser10388392hoarse_r
horses94729352ho_rses_
horsiest112513262ho_rsiest
sparsest1048822sparsest
arrest63722633__arrest
arses55733873__arses_
barest85327693_bar_est
basest84720493_ba_sest
bourses94014303bourses_
carses85233653_carses_
chariest13315513chariest
coaliest10316223coaliest
coarse84813903coarse__
coarsely1335533coarsely
coarsen93210323coarse_n
coarsens10348123coarsens
coarser93211203coarse_r
coassist10298803coassist
coattest1038863coattest
corses84433463co_rses_
corset85636223co_rse_t
corsets94819803co_rsets
courses94218893courses_
crassest103411523crassest
darkest122512623_darkest
dearest83618673dear_est
dourest8312943dour_est
dwarfest1543473dwarfest
earnest7318733_earnest
falsest10310013_falsest
foamiest13289853foamiest
forest94926743fo_r_est
glariest92012533glariest
goriest82218743go_riest
gorses74723293go_rses_
gorsiest92511133go_rsiest
haddest122711993h_addest
hairiest11612473hairiest
halest94823273h_a_lest
hanses95022633h_anses_
hardiest123416343h_ardiest
hardset113415833h_ardse_t
hares86255543h_ar_es_
harness102413933h_arness
harpist12312363h_arpist
harslet10315653h_arslet
harslets1137833h_arslets
harvests14246173h_arvests
hawses125113993h_awses_
haziest193313013h_aziest
headiest123015553headiest
headrest122910203headrest
headset11312603headse_t
headsets1236053headsets
hearse94114273hearse__
hearsed113811403hearse_d
heartiest12311103heartiest
heaviest143210443heaviest
hoagies112811993hoagies_
hoarded12368343hoarde_d
hoarder11329233hoarde_r
hoarders12307433hoarders
hoards104912623hoar_ds_
hoarfrost1552163hoarfrost
hoarier104211743hoarie_r
hoariness1238823hoariness
hoars85925553hoar__s_
hoarsened1344053hoarsened
hoarseness1345313hoarseness
hoaxes163611693hoa_xes_
hocuses121710433hocuses_
hoises94823683ho_ises_
hokiest144114243ho_kiest
holiest104319623ho_liest
homiest124116633ho_miest
honest94822423ho__nest
honestest1247303honestest
hoodiest122413173hoodiest
hookiest152712103hookiest
hootiest113115643hootiest
hoppiest152610733hoppiest
hordes104921633ho_rdes_
hornet94926433ho_rne_t
hornets104113553ho_rnets
horniest112814043horniest
hornist102314823ho_rnist
horrent10313553ho_rrent
horridest1345643horridest
horse86132653ho_rse__
horsed105321083ho_rse_d
horseshit1544783ho_rseshit
horsey125115403ho_rse_y
horst85833513ho_r__st
horstes104516113ho_rstes_
horsts95817513ho_rsts_
hoses85443183ho__ses_
hottest10411383ho_ttest
houses96032283ho_uses_
housesat1146483ho_usesat
housesit1177093ho_usesit
largest83715103_largest
leariest83117853leariest
loamiest102310213loamiest
loosest75811563lo_osest
marses84827113_marses_
mooriest102812723mooriest
nearest73415843near_est
oakiest112913923_oakiest
oarless73913373_oarless
oases55330983_oa_ses_
parses85534703_parses_
peartest10311303peartest
poorest9312773poor_est
rarest65725483_rar_est
rearrest8311603rearrest
scarcest12169173scarcest
scariest101615953scariest
searest73322023sear_est
sharpest1339153sharpest
shoalest1168913shoa_lest
shoaliest1238513shoaliest
shortest11310783sho_rtest
smartest10310183smartest
soapiest102412853soapiest
sorest65028003so_r_est
sorriest8413883sorriest
sourest7515713sour_est
sparest94616433spar_est
starkest1239723starkest
tartest72517533_tartest
teariest82417263teariest
tersest71713993_tersest
torses64727953to_rses_
wariest105122503_wariest
warmest123113033_warmest
weariest112914793weariest
worses95522953wo_rses_
worset96726583wo_rse_t
worsets105512843wo_rsets
yarest95018913_yar_est

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621517.00320871.3
3Display Results1511510.0602516.7
 (SQL Overall)1786911517.48323879.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.