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

220 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
leachier133725(None) 
beachier1538801beachier
leacher124014841leach_er
peachier1548621peachier
achier113914262__achier
beechier1535632beechier
bleacher15358882bleach_er
heathier1438342heathier
lacier84020092l_ac_ier
lathier10310832l_athier
leached133715042leach_ed
leachers133712812leach_ers
leaches123319342leach_es
leachiest1437252leachiest
leaching143012832leaching
leadier83212722lea_dier
leafier10329832lea_fier
leakier114010992lea_kier
learier73415662lea_rier
leather103815782leath_er
leavier10319992lea_vier
lecher113415852le_ch_er
peacher144216072peach_er
poachier1556822poachier
preachier1646922preachier
reacher123718292reach_er
reechier1336672reechier
teacher123714832teach_er
techier1269242te_chier
tetchier1336452tetchier
ashier94714833__ashier
beached154516553beach_ed
beaches144120653beach_es
beachgoer1742313beachgoer
beachiest1638453beachiest
beaching164114143beaching
beachwear1941773beachwear
beadier103513913bea_dier
beakier134012163bea_kier
beamier113411943bea_mier
belcher143511493belch_er
bencher144113483bench_er
bitchier15307733bitchier
bleached16378563bleach_ed
bleachers16297923bleach_ers
bleaches153410673bleach_es
bleaching17287093bleaching
blearier1037333blea_rier
blencher15308393blench_er
blotchier1643213blotchier
botchier15287143botchier
branchier1637133branchier
brashier13389933brashier
breacher153011503breach_er
breathier1435383breathier
bunchier1536153bunchier
cahier113615773_ca_hier
cashier123713323_cashier
catchier15329863catchier
chichier1836023chichier
cleanlier1143363cleanlier
clencher15277973clench_er
coacher143714123coach_er
dashier114311183_dashier
deadlier1036863deadlier
decrier102713563de_crier
descrier1157623descrier
detacher1437543detach_er
earlier72612743_earlier
earthier1137443_earthier
easier64218463_ea_sier
echoer114011103_e_choer
etcher113912943_etch_er
feather133613503feath_er
featlier1136453featlier
fetcher153510393fetch_er
flashier1437103flashier
fleecier1334763fleec_ier
fleshier1435603fle_shier
fletcher16306663fletch_er
glacier103911303glac_ier
gleamier1144913glea_mier
glitchier1542793glitchier
headachier1952353headachier
headier113212953hea_dier
healthier1544253healthier
heartier1139093heartier
heather133914853heath_er
heavier13429423hea_vier
itchier12247673_itchier
kerchief2043873kerchief
kvetchier2141863kvetchier
lacer75833753l_ac__er
laches116528353l_ach_es
lacker125325623l_ac_ker
lacquer18135153l_acquer
lakier104716273l_a_kier
lambier113611643l_ambier
lankier113711633l_ankier
lardier83518343l_ardier
larkier113711523l_arkier
lasher94824533l_ash_er
lather95124363l_ath_er
lazier154214613l_a_zier
leach105422523leach___
leachate1347443leachate
leachates1446663leachates
leachy14419733leach__y
leader74824653lea__der
leaguer835793lea_guer
leaker104620073lea__ker
lealties8310793lealties
leaner64022193lea__ner
leaper88118943lea__per
learner7319383lea_rner
leaser65322673lea__ser
leashed113211163leash_ed
leashes103514403leash_es
leashing123310313leashing
leathern11398913leath_ern
leathers114215083leath_ers
leathery14438973leath_ery
leaver94321513lea__ver
leched123716003le_ch_ed
lechers123313963le_ch_ers
lechery15257643le_ch_ery
leches115421313le_ch_es
leching134613653le_ching
lechwe1435113le_chwe_
lechwes1535063le_chwes
ledgier9458503le_dgier
leeched13369503leech_ed
leeches123911933leech_es
leeching14318373leeching
leerier73111503le_erier
legacies1139043legac_ies
leggier9368233le_ggier
lengthier1342413lengthier
letched133912053letch_ed
letches124015483letch_es
letching143810263letching
levier94013873le__vier
loaches123613983loach_es
loamier9349163loa_mier
loather103711003loath_er
luckier133811533l_uckier
luncher123111413lunch_er
lurcher12338133lurch_er
luthier1038233l_uthier
lyncher15366553lynch_er
mealier93015903mea_lier
measlier1036013measlier
meatier93214613mea_tier
meshier123410853me_shier
nearlier836803nearlier
pacier105018683_pac_ier
patchier15319663patchier
peached154315883peach_ed
peachers153213843peach_ers
peaches144120053peach_es
peachiest1638533peachiest
peaching163613643peaching
peakier134411443pea_kier
pearlier1037323pearlier
peatier94017233pea_tier
peckier153910523pe_ckier
percher143313423perch_er
pitchier15368273pitchier
plashier1337613plashier
pleached16338063pleach_ed
pleaches153210433pleach_es
pleaching17257083pleaching
pleather1356653pleath_er
poacher143912323poach_er
pouchier1546803pouchier
preacher153211373preach_er
punchier1536413punchier
quackier23215373quackier
racier85120973_rac_ier
reached134619083reach_ed
reachers133515723reach_ers
reaches123423203reach_es
reaching143317203reaching
readier83117423rea_dier
recamier1237603recamier
seamier93114633sea_mier
searcher13209103search_er
sketchier1853413sketchier
sleazier1735123slea_zier
slouchier1443603slouchier
snatchier1455353snatchier
spacier114011633spac_ier
starchier1436643starchier
stenchier1445333stenchier
tackier133712523_tackier
teachers133212393teach_ers
teaches122718353teach_es
teaching143612603teaching
tearier73815613tea_rier
techie11511723te_chie_
techies12513603te_chies
thatchier1743983thatchier
torchier1337463torchier
touchier1347383touchier
trashier113210103trashier
treaclier1144153treaclier
vealier102712173vea_lier
wackier16369733_wackier
washier133611153_washier
weaklier1534263weaklier
wealthier1543263wealthier
wearier103613283wea_rier
weather133513223weath_er
welcher15319393welch_er
wencher153811133wench_er
whackier2044673whackier
witchier16307883witchier
wrathier1435903wrathier
yachter1534913_yachter
yeastier1135393yeastier

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622208.03018202.0
3Display Results2202200.0802750.0
 (SQL Overall)1786912208.53320941.2
 
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.