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

125 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
drenchers1529610(None) 
drencher14257211drencher_
drenches14309801drenche_s
trenchers14288071trenchers
wrenchers17256331wrenchers
benchers153611012_benchers
blenchers16356722blenchers
breachers16369852breachers
brunchers16296252brunchers
clenchers16276552clenchers
crunchers16316242crunchers
drenched15247912drenche_d
frenches163311632frenche_s
preachers16339572preachers
quenchers2343172quenchers
ranchers133311792_ranchers
reachers133515722_reachers
trencher13279312trencher_
trenches133512602trenche_s
wenchers16319212_wenchers
wrencher16287782wrencher_
wrenches163210232wrenche_s
archers124414573ar__chers
bedrenches1843453bedrenche_s
belchers153510023_belchers
bencher144113483_bencher_
benches143918603_benche_s
blanchers16307433blanchers
bleachers16297923bleachers
blencher15308393blencher_
blenches153310763blenche_s
branches153613803branche_s
breacher153011503breacher_
breaches153714123breache_s
breathers14319103breathers
breeches15258673breeche_s
broachers16328153broachers
bruncher15347783bruncher_
brunches153710453brunche_s
clencher15277973clencher_
clenches152910953clenche_s
clinchers16336263clinchers
cranches153114543cranche_s
creches14313093cre_che_s
cruncher15338073cruncher_
crunches153711353crunche_s
dancers103413093d_anc_ers
deckers144413833d_e_ckers
deicers103612733d_eic_ers
deniers84515183d_en_iers
denuders10165873d_enuders
detachers1536483detachers
diethers1257453die_thers
ditchers143610363d_itchers
dreamers11369003dre_amers
dredgers11256093dre_dgers
drench12369593drench___
drenching16256033drenching
dressers9359863dre_ssers
drinkers13277823drin_kers
droners84114383dron__ers
druthers1275793dr_uthers
dunches133312583d_unche_s
erecters102611613ere_cters
etchers123411293__etchers
fencers123810623_fenc_ers
fetchers16328863_fetchers
flenches163410533flenche_s
fletchers17335533fletchers
flinchers17295473flinchers
frenched17299433frenche_d
frescoers1454563frescoers
grinches1436953grinche_s
inchers123912523__inchers
kenches163912273_kenche_s
kvetchers2142373kvetchers
launchers1454333launchers
leachers133712813_leachers
lechers123313963_le_chers
lunchers13349563_lunchers
lynchers16285453_lynchers
munchers15318773_munchers
peachers153213843_peachers
perchers153611523_perchers
pinchers153510613_pinchers
plenches153110623plenche_s
prancers123210333pranc_ers
preacher153211373preacher_
preaches153214893preache_s
punchers152610073_punchers
quencher2234123quencher_
quenches2236013quenche_s
rancher123013633_rancher_
ranchero13277423_ranchero
rancheros14255793_rancheros
ranches123620113_ranche_s
reacher123718293_reacher_
reaches123423203_reache_s
rechews1537293_re_chews
renders83821673_ren_ders
renegers9248793_renegers
renewers11238183_renewers
renters74224823_ren_ters
rentiers83311763_rentiers
rescuers1037363_rescuers
retches123318513_retche_s
screechers17143683screechers
sketchers1834513sketchers
spencers12269193spenc_ers
stanchers14206813stanchers
stenches132110293stenche_s
stretchers1545173stretchers
teachers133212393_teachers
tenches123515523_tenche_s
tranches132915513tranche_s
treachery1744693treachery
trenched14289853trenche_d
welchers16338053_welchers
wencher153811133_wencher_
wenches152914133_wenche_s
winchers16319223_winchers
wreathers15257493wreathers
wreckers17315973wre_ckers
wrenched17748133wrenche_d
wretches16257283wretche_s

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411256.68622231.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.16824929.0
 
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.