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

339 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
lank8473444(None) 
bank105835741bank
blank115418551blank
clank114719521clank
dank95828231dank
flank124618091flank
hank115134131hank
lack105837681lack
land56337301land
lane45153321lane
lang56637371lang
lanky125517481lanky
lark85733861lark
link86943441link
lunk86030721lunk
plank115221141plank
rank85135521rank
sank85236821sank
slank95822771slank
tank85134011tank
wank115632501wank
yank115423661yank
alack114820062alack
alan46844082alan_
aland65526412aland
alane56135612alane
alang66023512alang
alans55636172alans
alant55742292alant
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
ani37751172_ani
ankh111114412_ankh
ant37270782_ant
any68440482_any
ark77044962_ark
ask77130702_ask
auk76234142_auk
back125535762back
balk105132222balk
ban58366832ban_
band76740902band
bane65250422bane
bang74836992bang
bani65334952bani
banks115527902banks
bans66555132bans
bark106242152bark
bask105131422bask
black134719072black
bland85320452bland
blanks124112892blanks
blink115720142blink
bonk105531712bonk
brank115222282brank
bunk105731352bunk
calk105527662calk
can57760132can_
cane66653112cane
cans65050842cans
cant66362022cant
cark105539272cark
cask105626432cask
clack134720172clack
clan65633922clan_
clang86019312clang
clanks124615182clanks
clanky15469072clanky
clans75031012clans
clink115320042clink
clonk114417442clonk
clunk114215082clunk
conk106531442conk
crank114819612crank
dak86340692da_k
dan46859662dan_
dang65131532dang
dans56748142dans
dark95133212dark
dawk126117282dawk
dink97137802dink
drank104816202drank
dunk96228572dunk
elan46734242elan_
eland65820392eland
elans55527752elans
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fink117532122fink
flack144519412flack
flak116026172fla_k
flan76134182flan_
flanks133913402flanks
flans85327972flans
flask125512422flask
flunk125014382flunk
frank124417512frank
funk115825622funk
gan48060122gan_
gane55145292gane
gang66031962gang
gawk126716692gawk
gink97129522gink
gland75217712gland
glans65125832glans
gunk95423572gunk
hack135134542hack
haik115526982haik
hand86833702hand
hang85535542hang
hanks126226862hanks
hanky155418292hanky
hant75461582hant
hark115237392hark
hawk145521152hawk
honk116931192honk
hunk116029542hunk
ink76433632_ink
jack175224862jack
jane115031472jane
jauk155816092jauk
jink156227202jink
junk155121032junk
kana85928522kana
kane85133962kane
kink76034392kink
konk79320612konk
la219261632la__
lab58864782la_b
labs67145122labs
lac510155822la_c
lace66848472lace
lacks116129202lacks
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
lade56345982lade
lads56549132lads
lady86527152lady
lag47862122la_g
lags56546222lags
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
lake85741602lake
lakh114919952lakh
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
lamp86233822lamp
lams66552262lams
lanai5319572lanai
lance75126722lance
lands65426902lands
lanes54946792lanes
lanker104123002lanker
lankly13439622lankly
lap58565272la_p
laps66848872laps
lar37967532la_r
lard56742002lard
lari45839152lari
larks95227812larks
larky125218872larky
lars46956572lars
las37281472la_s
lase46148512lase
lash76539652lash
lass47444542lass
last46260322last
lat37593402la_t
late47560482late
lath76640382lath
lati46438272lati
latke94817092latke
lats45962702lats
latu47934182latu
laud56527722laud
lav66847342la_v
lava76725422lava
lave75642142lave
lavs76734152lavs
law68656642la_w
lawn75925632lawn
lawns85215422lawns
lawny115912012lawny
laws76441682laws
lax107651522la_x
lay68865352la_y
lays76043252lays
laze136235052laze
lazy166423072lazy
leak86233712leak
lean46345242lean_
leans55536252leans
leant56737782leant
leek85331732leek
lek75640302l_ek
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
liana53915892liana
liane54720662liane
liang64914412liang
lick106935072lick
lin37967372lin_
line46965572line
ling57447962ling
links96430192links
linky127622382linky
linn46034592linn
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
llano5910602llano
loan47436452loan_
loans56026462loans
lock106134362lock
lone45849132lone
long56933342long
look87333472look
luck105329822luck
luna46229852luna
lune47140492lune
lung55732492lung
lunks94822452lunks
lunt46148842lunt
luny77324132luny
lurk86624162lurk
lynx1437422lynx
mack125733642mack
man57465852man_
mana65341942mana
mane65052012mane
mano66536792mano
mans66354532mans
many95731842many
mark105138052mark
mask105227352mask
mink106636522mink
monk105928512monk
nan37854872nan_
nana46632892nana
nans46139392nans
nark85230062nark
oak76238652oa_k
oink85429342oink
pack125535442pack
paik105726802paik
pan58466442pan_
pane64950282pane
pang75336282pang
pans65855722pans
pant66061252pant
park105237492park
pink107039382pink
plack135017842plack
plan65833942plan_
plane74929142plane
planks124116752planks
plans75731272plans
plant75437112plant
plink115219122plink
plonk114613982plonk
plunk114514402plunk
prank115019452prank
punk105729972punk
rack106234882rack
ran38266612ran_
rand55839562rand
rang56939152rang
rani46640102rani
ranks95225732ranks
rant45864672rant
rink87736992rink
sack105337312sack
sand55338462sand
sane45954332sane
sang55441222sang
sans45153352sans
sark84938972sark
shank125422192shank
sink86640142sink
skank84415582skank
slack115021762slack
slang66324022slang
slant55238702slant
slink95422912slink
slunk95016302slunk
spank115919572spank
stank95823302stank
sunk85031812sunk
swank125318232swank
tack106536292tack
talk86230092talk
tan37167562tan_
tang56138662tang
tanka93817482tanka
tanks94624732tanks
tans46154812tans
task85326652task
thank125817802thank
trank96222422trank
ulan46527392ulan_
ulans54921302ulans
van66246322van_
vane75534682vane
vang84926032vang
vans76236722vans
wack135330912wack
walk115625612walk
wan66761932wan_
wand85833872wand
wane76344712wane
wanks126124482wanks
wans76452262wans
want76156162want
wany106432352wany
wark115737772wark
wauk115220592wauk
wink116435022wink
wonk116125302wonk
yack135425972yack
yak107038562ya_k
yang85626062yang
yanks125316572yanks
zany167316982zany
zonk175018622zonk

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.0762351197.4
2DLD Change Limit298723391.00029872.0
3Display Results3393390.1232756.1
 (SQL Overall)1786913391.199149033.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.