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

207 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
ilk7832531(None) 
bilk105824431bilk
elk76726121elk
ick97329331ick
ilka87215151ilka
ilks87218571ilks
ill37437101ill
ink76433641ink
irk76426371irk
milk105028481milk
silk85529331silk
ail37171052ail_
ails45654722ails
al210674042al_
ala312463602ala
alb57342652alb
ale36572342ale
alky115920342alky
all36148232all
alp56641132alp
als36663022als
alt36467962alt
ark77044962ark
ask77130702ask
auk76234142auk
balk105132222balk
bile66147192bile
bilks115117892bilks
bill67239952bill
birk106326872birk
bisk106523362bisk
bulk105426152bulk
calk105527662calk
dak86340692dak
dick116432392dick
dill55239982dill
dink97137812dink
dirk96326842dirk
disk96625842disk
eek77935102eek
el26745292el_
eld46733802eld
elf66138522elf
elks85820032elks
ell36735682ell
elm57531742elm
els37645722els
fil65447152fil_
fila74729142fila
file75446652file
fill75540202fill
film94828182film
filo76034292filo
fils75838702fils
fink117532132fink
flak116026172flak
flu66530212flu
fly97124952fly
folk116021542folk
gild65526522gild
gill56336192gill
gilt56348552gilt
gink97129532gink
hick135530312hick
hila76228362hila
hili75626642hili
hill76439502hill
hilt75850722hilt
holk116027942holk
hulk115321612hulk
ice56737252ice
ich86227752ich
icky136315752icky
icy86322132icy
id38941852i_d
idle55423772idle
idly85617332idly
ids47535482ids
if57239962i_f
iff96730402iff
ifs67124252ifs
igg57116802igg
iglu510814782iglu
ilea45931462ilea
ilex115822032ilex
ilia46026822ilia
ills47030422ills
illy76925332illy
imp76626982imp
in28150872i_n
inks86926502inks
inky115321582inky
inly75622212inly
inn36727442inn
ins35945612ins
ion36051032ion
ire36943182ire
irks86220132irks
is27048222i_s
isle45121702isle
ism56322392ism
it28455692i_t
its35538842its
ivy96317452ivy
jill116430272jill
jilt115839432jilt
jink156227212jink
kick96026082kick
kill85533192kill
kiln85620992kiln
kilo86028682kilo
kilt86144432kilt
kink76034412kink
kirk76221582kirk
klik74412662klik
la219261632_la
lek75640302lek
li29948762_li
lib57750282lib
lick106935082lick
lid47453532lid
lie38264532lie
like86040852like
lilo46731572lilo
lilt46349952lilt
lily76730192lily
lin37967382lin
link86943452link
lip514755812lip
lis37162282lis
lit39377322lit
lo28053442_lo
mick126333442mick
mil55752122mil_
mild75330862mild
mile66352582mile
milks115020582milks
milky144014442milky
mill66541492mill
milo65536112milo
mils66045342mils
milt65455822milt
mink106636542mink
mirk106729512mirk
nick106627612nick
nil36144202nil_
nill45634312nill
nils46132462nils
oak76238652oak
oil37452062oil_
oils46337982oils
oily77932262oily
oink85429352oink
old47033472old
ole37155212ole
pick125933822pick
pile65649702pile
pili66130362pili
pill65339472pill
pily96132742pily
pink107039392pink
ply86323552ply
rick107334662rick
rile45650542rile
rill45140912rill
rink87737002rink
risk85724112risk
sick106435582sick
sild55030592sild
silks94620682silks
silky125315822silky
sill45545162sill
silo46037922silo
silt46558202silt
sink86640152sink
sly66228562sly
suk75632972suk
sulk85326652sulk
talk86230092talk
tick106231232tick
til36350272til_
tilak91011552tilak
tile45451452tile
till45941212till
tils45739622tils
tilt46252432tilt
tsk75814732tsk
ulu36028702ulu
vile76139812vile
vill75235082vill
walk115625612walk
wick135726312wick
wild85126522wild
wile75944382wile
will75737522will
wilt76246302wilt
wily106428822wily
wink116435032wink
wok106334172wok
yak107038562yak
yelk115320002yelk
yill75628982yill
yok107335242yok
yolk116218992yolk
yuk106725602yuk
zek167323162zek
zill135727622zill

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140842070.40634689.7
3Display Results2072070.0464500.0
 (SQL Overall)1786912070.702254545.6
 
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.