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

169 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
headrest12291020(None) 
headiest123015551headiest
headrests13245021headrests
beadiest113815532beadiest
deadest93014882dead_est
dearest83618672dea_rest
haddest122711992h_addest
hardest113118412h_ardest
headdress1443752headdress
headers113819392headers_
headless12289862headless
headmost1445492headmost
headset11312602headse_t
headsets1236052headsets
heaviest143210442heaviest
leadiest93314982leadiest
nearest73415842nea_rest
readiest93719042readiest
rearrest8311602rearrest
searest73322022sea_rest
addrest958633_addrest
airest63825263__airest
arrest63722633__arrest
baddest112611143_baddest
barest85327693_ba_rest
beaders104120183beaders_
beadles103414733beadles_
beakiest143313463beakiest
beamiest123212763beamiest
bendiest112311983bendiest
cadres94017933_cadres_
cheapest1536073chea_pest
clearest1038653clea_rest
deadbeat1245803deadbeat
deadliest1138183deadliest
deadness1039233deadness
deafest112911513dea_fest
deediest102912253deediest
deforest1238793deforest
demurest1137453demurest
drest65530343___drest
eagerest9510273_eagerest
eagres74014573_eagres_
earnest7318733_earnest
easiest72318773_easiest
eldest72912683_eld_est
eldress835003_eldress
fairest10412293_fairest
featest102715113fea_test
gladdest11145843gladdest
gladiest101710333gladiest
hades96035113h_ad_es_
hadjes175210403h_adjes_
hadst93220223h_ad__st
haeres94017033h_aeres_
hairiest11612463h_airiest
halest94823273h_a_lest
handiest123417773handiest
hardiest123416333hardiest
hardset113415833h_ardset
hares86255543h_a_res_
harvest132112753h_arvest
haziest193313003h_aziest
headed114020473head_e_d
headend12398363head_end
header104422543head_e_r
headfirst1642813headfirst
headfish1845443headfish
headgear1343373headgear
headhunt1544693headhunt
headier113212953headie_r
headiness132510363headiness
headmen13259513headme_n
headrace1446663headrace
headraces1546613headraces_
headroom1446303headroom
heads95127113head__s_
healers104319463healers_
heapers123616673heapers_
hearer94323643hea_re_r
hearers104319783hea_rers
hears86737373hea_r_s_
hearse94114273hea_r_se
hearsed113811403hea_rsed
hearses104414533hea_rses
heart85440743hea_r__t
heartiest12311103heartiest
hearts96218943hea_rts_
heaters104225223heaters_
heathiest1549383heathiest
heatless113011463heatless
heaumes1237423heaumes_
heavers133717193heavers_
heaves124120303hea_ves_
heavies132713873heavies_
heavyset1744093heavyset
heddles123311623heddles_
heders104119763he_ders_
hedges115016263he_dges_
hedgiest13298133hedgiest
heeders114213743heeders_
heedless12278813heedless
heftiest1439183heftiest
heiress1036813he_iress
hempiest1539033hempiest
heppest14228143he_ppest
herbiest1339993herbiest
herders113914123herders_
hereat93527413he__reat
heres86245903he__res_
heresy125011233he__resy
hexades18378703hexad_es_
hoariest11312883hoariest
hoarsest1137133hoarsest
hoodiest122413173hoodiest
leaders83819603leaders_
leadless9248793leadless
leafiest113410883leafiest
leakiest123212793leakiest
leanest7415863lea_nest
leariest83117843leariest
leaviest112910813leaviest
lewdest1136283lewd_est
maddest112311213_maddest
madres93718183_madres_
mealiest102215973mealiest
meanest9315703mea_nest
meatiest102816793meatiest
merest84725113me__rest
neatest72516003nea_test
neediest92611303neediest
nerdiest92511163nerdiest
padres95016983_padres_
peakiest143512993peakiest
peartest10311303peartest
peatiest103118803peatiest
rarest65725483_ra_rest
readdress1143823readdress
readers83823773readers_
readies83324713readies_
readjust1644463readjust
realest73322433rea_lest
rearrests945313rearrests
reddest9311953re_ddest
redress82511873re_dress
reediest92815423reediest
reforest1139963reforest
saddest92412383_saddest
seamiest102715413seamiest
securest1058583securest
sedatest9249393sedatest
seediest92714053seediest
serest64831613se__rest
severest11310323severest
shadiest121711273shadiest
sheerest11310083she_erest
sparest94616423spa_rest
steadiest1038513steadiest
teariest82417263teariest
tenderest1047903tenderest
theatres11298633theatres_
threadiest1444283threadiest
undrest8313013_undrest
vealiest112513203vealiest
weakest1439003wea_kest
weariest112914793weariest
weediest122311133weediest
weirdest1244433weirdest
yarest95018913_ya_rest

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.453394461.4
2DLD Change Limit1461621697.39319770.3
3Display Results1691690.0602816.7
 (SQL Overall)1786911697.90622601.9
 
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.