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

358 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
land5633730(None) 
aland65526411aland
and47244161_and
band76740901band
bland85320451bland
eland65820391eland
gland75217711gland
hand86833701hand
lad48165701la_d
laid56439141laid
lands65426901lands
lane45153321lane
lang56637371lang
lank84734441lank
lard56742001lard
laud56527721laud
lend56233671lend
rand55839561rand
sand55338461sand
wand85833871wand
ad311975032_a_d
add510132362_add
aid49269072_aid
alan46844082alan_
alands75418372alands
alane56135612alane
alang66023512alang
alans55636172alans
alant55742292alant
an211879072_an_
ana39559822_ana
ands57833612_ands
ane37866942_ane
ani37751172_ani
ant37270782_ant
any68440482_any
bad67763152ba_d
bald76432902bald
ban58366832ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250422bane
baned85436352baned
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bend76435262bend
bind76234502bind
blank115418552blank
blend85317452blend
blind86319322blind
blond85618372blond
bond75334362bond
brand85124492brand
bund75530662bund
cad67456362ca_d
caid77837532caid
can57760132can_
candy115119822candy
cane66653112cane
caned85838092caned
canid85526342canid
cans65050842cans
cant66362022cant
card710245872card
clad76225822cla_d
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
dad58456162da_d
dan46859662dan_
dandy104416702dandy
dang65131532dang
dank95828232dank
dans56748142dans
elan46734242elan_
elands74914772elands
elans55527752elans
end46834352_end
fad77452412fa_d
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fard85639062fard
fend84832972fend
find87532602find
flan76134182flan_
flank124618092flank
flans85327972flans
fond86330952fond
fund85624982fund
gad57556652ga_d
gaed66031512gaed
gan48060122gan_
gane55145292gane
gang66031962gang
gaud67025432gaud
glad65624012gla_d
glands85314402glands
glans65125832glans
grand75122692grand
had77658762ha_d
haed86338582haed
hands95327382hands
handy125520872handy
hang85535542hang
hank115134132hank
hant75461582hant
hard85443502hard
hind85529752hind
inland7310312inland
island738532island
jane115031472jane
kana85928522kana
kane85133962kane
kind96128552kind
la219261632la__
lab58864782la_b
labs67145122labs
lac510155822la_c
lace66848472lace
laced87132642laced
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lade56345982lade
laded74232612laded
lads56549132lads
lady86527152lady
lag47862122la_g
lagend838742lagend
lags56546222lags
laic65931562laic
lain46146282lain
lair45934152lair
laird65417792laird
lake85741602lake
laked105731122laked
lakh114919952lakh
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
lamed85235292lamed
lamp86233822lamp
lams66552262lams
lanai5319572lanai
lance75126722lance
lanced93717722lanced
landau7310612landau
landed84619242landed
lander74028482lander
lanes54946792lanes
lanky125517482lanky
lap58565272la_p
laps66848872laps
lar37967532la_r
lards65331862lards
lardy96119272lardy
lari45839152lari
lark85733862lark
lars46956572lars
las37281472la_s
lase46148512lase
lased65132342lased
lash76539652lash
lass47444542lass
last46260322last
lat37593402la_t
late47560482late
lated65240672lated
lath76640382lath
lati46438272lati
lats45962702lats
latu47934182latu
lauds65618482lauds
lav66847342la_v
lava76725422lava
lave75642142lave
laved95028592laved
lavs76734152lavs
law68656642la_w
lawed96028322lawed
lawn75925632lawn
lawns85215422lawns
lawny115912012lawny
laws76441682laws
lax107651522la_x
lay68865352la_y
layed95127382layed
lays76043252lays
laze136235052laze
lazed154925842lazed
lazy166423072lazy
lead56038852lead
lean46345242lean_
leaned73422542leaned
leans55536252leans
leant56737782leant
led46254552l_ed
lends65326252lends
leno47331392leno
lens46146492lens
lent46360532lent
leud57223422leud
lewd85716592lewd
liana53915892liana
liane54720662liane
liang64914412liang
liard65418592liard
lid47453512l_id
lied55838092lied
ligand85011292ligand
lin37967372lin_
lindy96918312lindy
line46965572line
lined64934642lined
ling57447962ling
link86943442link
linn46034592linn
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
llano5910602llano
load56730602load
loan47436452loan_
loaned73816292loaned
loans56026462loans
loid55531482loid
lone45849132lone
long56933342long
lord55032082lord
loud55228042loud
luna46229852luna
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lyard95113212lyard
lynx1437422lynx
mad68958702ma_d
maid75537632maid
man57465852man_
mana65341942mana
mane65052012mane
maned86634092maned
mano66536792mano
mans66354532mans
many95731842many
maud75325392maud
maund85515442maund
mend75334022mend
mind75434362mind
nan37854872nan_
nana46632892nana
nans46139392nans
nard56634452nard
pad68057322pa_d
paid75737482paid
pan58466442pan_
panda85022612panda
pandy115021172pandy
pane64950282pane
paned85437182paned
pang75336282pang
pans65855722pans
pant66061252pant
pard76441322pard
pend75934532pend
plaid85118302plaid
plan65833942plan_
plane74929142plane
planed94420912planed
plank115221142plank
plans75731272plans
plant75437112plant
pond75530492pond
qaid146023842qaid
rad47662002ra_d
raid55243072raid
ran38266612ran_
rands65930452rands
randy95022082randy
rang56939152rang
rani46640102rani
ranid66429332ranid
rank85135522rank
rant45864672rant
reland75920432reland
rend56136572rend
rind56535602rind
rynd86414102rynd
sad47459202sa_d
said55742112said
sands65228582sands
sandy94221132sandy
sane45954332sane
saned65636272saned
sang55441222sang
sank85236822sank
sans45153352sans
sard55344242sard
send55237292send
slang66324022slang
slank95822772slank
slant55238702slant
soland75115042soland
stand65923282stand
tad47959822ta_d
tan37167562tan_
tang56138662tang
tank85134012tank
tans46154812tans
tend56433772tend
ulan46527392ulan_
ulans54921302ulans
ulnad65611452ulnad
upland938862upland
van66246322van_
vanda94515922vanda
vane75534682vane
vaned94622422vaned
vang84926032vang
vans76236722vans
vend86626422vend
viand9511072viand
wad77053892wa_d
wan66761932wan_
wands96425482wands
wane76344712wane
waned95831782waned
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
ward86542252ward
wend85330452wend
wind85533852wind
wynd116114462wynd
yald86920602yald
yang85626062yang
yank115423662yank
yard85633252yard
yaud87020082yaud
yond86122312yond
zany167316982zany

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.1101624463.6
2DLD Change Limit298723580.89033564.0
3Display Results3583580.0933849.5
 (SQL Overall)1786913581.093163486.7
 
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.