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

284 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
sild5503059(None) 
gild65526521gild
mild75330861mild
silds65520531silds
silk85529331silk
sill45545161sill
silo46037921silo
silt46558201silt
slid55828991slid
sold54837411sold
wild85126521wild
aid49269092ai_d
ail37171052ail_
ailed66240282ailed
ails45654722ails
auld54125362auld
bald76432902bald
bid67751822bi_d
bield84614652bield
bile66147192bile
bilk105824432bilk
bill67239952bill
bind76234522bind
bird76128332bird
bold75432812bold
build84413352build
child114516222child
cold77338772cold
did56850532di_d
died66137862died
dildo71911782dildo
dill55239982dill
eld46733802_eld
fid76847702fi_d
field95015322field
fil65447152fil_
fila74729142fila
file75446652file
filed95331902filed
fill75540202fill
film94828182film
filo76034292filo
fils75838702fils
find87532612find
fold86528942fold
geld65828432geld
gid57047282gi_d
gied64631992gied
gilds75417532gilds
gill56336192gill
gilt56348552gilt
gird65425002gird
gold65430162gold
guild75312752guild
held85330402held
hid76248392hi_d
hied85434052hied
hila76228362hila
hili75626642hili
hill76439502hill
hilt75850722hilt
hind85529762hind
hold86235062hold
id38941852_i_d
ilk78325312_ilk
ill37437102_ill
isle45121702isle
isled64615992isled
jill116430272jill
jilt115839432jilt
kid86540632ki_d
kill85533192kill
kiln85620992kiln
kilo86028682kilo
kilt86144432kilt
kind96128572kind
lid47453532li_d
lied55838102lied
lilo46731572lilo
lilt46349952lilt
lily76730192lily
meld75830472meld
mid67354482mi_d
mil55752122mil_
milds86422062milds
mile66352582mile
milk105028482milk
mill66541492mill
milo65536112milo
mils66045342mils
milt65455822milt
mind75434392mind
mold76034332mold
nil36144202nil_
nill45634312nill
nils46132462nils
oil37452062oil_
oiled64429472oiled
oils46337982oils
oily77932262oily
old47033472_old
pied75035372pied
pile65649702pile
piled85232992piled
pili66130362pili
pill65339472pill
pily96132742pily
rid46754642ri_d
rile45650542rile
riled65833252riled
rill45140912rill
rind56535612rind
sad47459212s_ad
said55742122said
sail45447162sail_
sailed74327762sailed
sails55738102sails
sal36462882sal_
salad65321832salad
sale44959702sale
sall44544682sall
salp64534092salp
sals46851672sals
salt45758522salt
sand55338472sand
sard55344242sard
scad75725772scad
scald84818122scald
scold85414862scold
scud76221282scud
seed55549482seed
sel38253322sel_
self75138292self
sell45840612sell
sels46345982sels
send55237292send
shad86230912shad
shed86536152shed
shied96125492shied
shield106212972shield
shill85325332shill
shily115222012shily
shod86225062shod
si29149582si__
sial45938842sial
sialid7314942sialid
sials54227242sials
sib56850322si_b
sibb85921432sibb
sibs65933552sibs
sic55847882si_c
sice65545602sice
sick106435582sick
sics65234102sics
side55444502side
sided74825962sided
sidh86223002sidh
sidle65124042sidle
sidled84215172sidled
sift710740672sift
sigh85625902sigh
sigla64515202sigla
sign55523062sign
sika86021332sika
sike87138792sike
silex123417412silex
silked114314812silked
silks94620682silks
silky125315822silky
sills55135992sills
silly84527622silly
siloed74615302siloed
silos56029432silos
silted74020012silted
silts55330822silts
silty84721632silty
silva82714022silva
sim56553152si_m
sima64730792sima
simp85228782simp
sims65737182sims
sin36265902si_n
sine46560632sine
sing57544182sing
sinh76238052sinh
sink86640152sink
sins46755282sins
sip57656022si_p
sipe67341052sipe
siped84927682siped
sips65740112sips
sir35746682si_r
sire46150422sire
sired66134282sired
sirs44338342sirs
sis37360552si_s
sit35877762si_t
site47052422site
sited65130742sited
sith75435162sith
sits45050212sits
six105339752si_x
size135630972size
sized155519242sized
sizy164816402sizy
skald104210172skald
skid95720942skid
skied104417762skied
skill94316732skill
sled55334372sled
slide64725422slide
slily85820032slily
slim66631962slim
slip67031732slip
slit46250102slit
sly66228562s_ly
smile74823922smile
smiled93716432smiled
sned56026052sned
sod46053712s_od
soil46138832soil_
soiled73822472soiled
soils55327982soils
sol37256622sol_
sola45541862sola
soldi65717202soldi
soldo67116562soldo
sole46053672sole
soled65835172soled
soli46637012soli
solid65025082solid
solo45538942solo
sols45448162sols
sord56237202sord
sped76031492sped
spied85427712spied
spile75230082spile
spiled94621992spiled
spill74821162spill
spilt75532222spilt
spud75818492spud
stied65723032stied
stile54931572stile
still54922082still
stilt54831982stilt
stud56220092stud
sudd64719782sudd
sued56537932sued
sulk85326652sulk
sulu45128422sulu
surd56433812surd
swill83417372swill
syli74318982syli
tied55535222tied
til36350272til_
tilde65017352tilde
tile45451452tile
tiled64832942tiled
till45941212till
tils45739622tils
tilt46252432tilt
told56132202told
veld85323202veld
vid77241822vi_d
vied86328642vied
vile76139812vile
vill75235082vill
weld84727732weld
wield95213912wield
wilds94818212wilds
wile75944382wile
wiled95231552wiled
will75737522will
wilt76246302wilt
wily106428822wily
wind85533862wind
wold85429072wold
yald86920612yald
yeld811423872yeld
yid76640842yi_d
yield9519692yield
yill75628982yill
yird87018992yird
zill135727622zill

Search took 3 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.576310227.4
2DLD Change Limit298722841.53319486.0
3Display Results2842840.0763736.8
 (SQL Overall)1786912842.18581780.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.