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 “lech” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

185 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
lech9682544(None) 
leach105422521leach
leech104913211leech
letch105215801letch
lich96230841lich
loch95527131loch
lych126015761lych
pech116125451pech
tech95925441tech
yech127220531yech
alec66430062alec_
alecs76620732alecs
aleph10311392aleph
arch98628442arch
bach116131392bach
beach124623892beach
beck126226572beck
beech124315502beech
belch124415502belch
bench125619502bench
beth96629232beth
bleach133611402bleach
blench133710452blench
ceca84820782ceca
clach124617822clach
clench133910052clench
deck115827752deck
deco76125972deco
each95530582each
eche97520282_eche
echo96615952_echo
echt95722902_echt
ecu56828232_ecu
edh76921562_edh
eh58339962_e_h
elect74327032elect
etch95419142etch
eth66630982_eth
feck134923432feck
feh96136092fe_h
fetch134913472fetch
fleche14299302fleche
fleck148213592fleck
fleech14367342fleech
flench144010812flench
flesh115013742flesh
fletch14388192fletch
geck115721992geck
heck135826492heck
heh96039622he_h
heth107028022heth
heuch135312332heuch
ich86227742_ich
inch95420822inch
itch95619172itch
keck94920712keck
kench145513922kench
ketch144912022ketch
lac510155822lac_
lace66848472lace
lack105837682lack
lacs66942482lacs
lacy95829632lacy
laich105920712laich
lakh114919952lakh
larch105919792larch
lash76539652lash
latch104620462latch
lath76640382lath
lea37660182le_a
leachy14419732leachy
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leap66032682leap
lear47045952lear
leas45954182leas
leash85519212leash
leched123716002leched
lecher113415852lecher
leches115421312leches
lechwe1435112lechwe
led46254552le_d
lee36068142le_e
leek85331732leek
leer46239352leer
lees45455882lees
leet45957902leet
left76340482left
leg46446112le_g
legs56133692legs
lehr75514942lehr
lei36846382le_i
leis45739602leis
lek75640302le_k
leke85527402leke
leks85427602leks
leku86519912leku
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
lept66440882lept
les35663072le_s
less45635102less
lest46956322lest
let36481472le_t
lethe85717302lethe
lets47147942lets
leu36047402le_u
leud57223422leud
lev66139422le_v
leva77020712leva
levo76820062levo
levy106418502levy
lewd85716592lewd
lex107943822le_x
ley66246812le_y
leys76430182leys
lez125541312le_z
lice66045062lice
lichi104412952lichi
licht104723492licht
lick106935072lick
loach105116362loach
loca65527682loca
lochs106715512lochs
loci66126282loci
lock106134362lock
loco67030742loco
loth76132132loth
luce65132572luce
luck105329822luck
lunch104917242lunch
lurch104814632lurch
lush75327692lush
lynch13468982lynch
mach116134482mach
merch125417962merch
mesh96823002mesh
meth95827842meth
much115224032much
neck105423662neck
ouch95724632ouch
peach125422492peach
pec76744412pec_
pechs125516202pechs
peck125730682peck
pecs84634102pecs
peh86740962pe_h
perch124518832perch
pleach134211242pleach
plench134010812plench
reach105123882reach
rec55645462rec_
reck106130562reck
recs65734182recs
resh76523452resh
retch104818302retch
rich97025542rich
sec55945322sec_
secs65033892secs
sect67443622sect
such96424812such
tach96132752tach
teach105221122teach
techs106915832techs
techy135612012techy
tench105620002tench
teth76327892teth
teuch105214852teuch
vetch134411842vetch
wecht13415442wecht
welch134411492welch
wench136214782wench
wich125724742wich
wych154011882wych
yeah106725412yeah
yecch15558092yecch
yechs136112582yechs
yechy16519082yechy
yeh97135772ye_h
yuch125818532yuch

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721850.90632971.3
3Display Results1851850.0464021.7
 (SQL Overall)1786911851.218146708.5
 
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.