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

160 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
trenchers1428807(None) 
drenchers15296101drenchers
trencher13279311trencher_
trenches133512601trenche_s
wrenchers17256331wrenchers
benchers153611012_benchers
blenchers16356722blenchers
breachers16369852breachers
brunchers16296252brunchers
clenchers16276552clenchers
crunchers16316242crunchers
drencher14257212drencher_
drenches14309802drenche_s
frenches163311632frenche_s
preachers16339572preachers
quenchers2343172quenchers
ranchers133311792_ranchers
reachers133515722_reachers
stretchers1545172stretchers
teachers133212392t_eachers
tenches123515522t_enche_s
tranches132915512tranche_s
treachery1744692treachery
trenched14289852trenche_d
wenchers16319212_wenchers
wrencher16287782wrencher_
wrenches163210232wrenche_s
archers124414573ar__chers
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
drenched15247913drenche_d
entrenches1545213entrenche_s
erecters102611613ere_cters
etchers123411293__etchers
fencers123810623_fenc_ers
fetchers16328863_fetchers
flenches163410533flenche_s
fletchers17335533fletchers
flinchers17295473flinchers
frenched17299433frenche_d
frescoers1454563frescoers
grinches1436943grinche_s
inchers123912523__inchers
intrenches1545813intrenche_s
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
renters74224813_ren_ters
rentiers83311763_rentiers
rescuers1037363_rescuers
retches123318513_retche_s
retrenches1545903retrenche_s
screechers17143673screechers
sketchers1834513sketchers
spencers12269193spenc_ers
stanchers14206813stanchers
stenches132110293stenche_s
stretcher1446293stretcher_
stretches1438293stretche_s
teacher123714833t_eacher_
teaches122718353t_eache_s
teenagers10114493teenagers
teeners74415453teen__ers
teethers11328713t_eethers
telphers1335473t_elphers
tenders83719723t_en_ders
tenners74014923t_en_ners
tenoners858713t_enoners
tenters73921103t_en_ters
tethers103815313t_e_thers
thatchers1744583thatchers
threshers1545423thre_shers
tochers123413093t__ochers
touchers133611213t_ouchers
tracers94917843tr_ac_ers
tracheas13410273tr_acheas
trackers143512853tr_ackers
trances93919643tranc_e_s
tranche123312223tranche__
transfers1238053transfers
trashers113013643tr_ashers
treacheries1645373treacheries
treacherous1652793treacherous
treacles1039703treacle_s
treaders93311843tre_aders
treadlers1045893treadlers
treaters83615843tre_aters
trebuchets1781603trebuchets
trekkers1133803tre_kkers
tremblers1334483tremblers
trench114211613trench___
trenchant1446333trenchant
trencherman1851723trencherman
trenchermen1851803trenchermen
trenching15227653trenching
trendier937913trendier_
trendies9312213trendie_s
trickers143812813tr_ickers
trochars1377853tr_ochars
trochees132510183tr_ochees
troches123715343tr_oche_s
trouncers1134803trounc_ers
truckers14279013tr_uckers
truncheon1442833truncheon
truncheons1542423truncheons
trundlers10215003trundlers
twitchers17134533twitchers
welchers16338053_welchers
wencher153811133_wencher_
wenches152914133_wenche_s
winchers16319223_winchers
wreathers15257493wreathers
wreckers17315973wre_ckers
wrenched17748133wrenche_d
wretches16257283wretche_s

Search took 9 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.186960704.3
2DLD Change Limit1486411607.81319024.8
3Display Results1601600.0602666.7
 (SQL Overall)1786911608.05922172.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.