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

332 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
lang5663737(None) 
alang66023511alang
bang74836991bang
clang86019311clang
dang65131531dang
fang85432541fang
gang66031961gang
hang85535541hang
lag47862121la_g
land56337301land
lane45153321lane
lank84734441lank
liang64914411liang
ling57447961ling
long56933341long
lung55732491lung
pang75336281pang
rang56939151rang
sang55441221sang
slang66324021slang
tang56138661tang
vang84926031vang
yang85626061yang
ag311067462_a_g
alan46844082alan_
aland65526412aland
alane56135612alane
alans55636172alans
alant55742292alant
along65419492along
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
anga56831352_anga
ani37751172_ani
ant37270782_ant
any68440482_any
bag67059222ba_g
ban58366832ban_
band76740902band
bane65250422bane
bangs85627772bangs
bani65334952bani
bank105835742bank
bans66555132bans
bhang115512922bhang
bland85320452bland
blank115418552blank
bong75633412bong
bung75730632bung
can57760132can_
cane66653112cane
cans65050842cans
cant66362022cant
chang115418562chang
clag75924572cla_g
clan65633922clan_
clangs95113612clangs
clank114719522clank
clans75031012clans
cling86424672cling
clung86013602clung
dag57753002da_g
dan46859662dan_
dangs75623202dangs
dank95828232dank
dans56748142dans
ding66940952ding
dong66031652dong
dung66328432dung
elan46734242elan_
eland65820392eland
elans55527752elans
eng46726782_eng
fag76852362fa_g
fan67158852fan_
fane75343562fane
fanga96119622fanga
fangs96224072fangs
fano75831682fano
fans76247362fans
flag87427082fla_g
flan76134182flan_
flange103411972flange
flank124618092flank
flans85327972flans
fling97023512fling
flong95815682flong
flung95114582flung
gag57753632ga_g
gan48060122gan_
gane55145292gane
gangs76222572gangs
gland75217712gland
glans65125832glans
gong66827192gong
hag77255742ha_g
hand86833702hand
hangs95726722hangs
hank115134132hank
hant75461582hant
hong85833952hong
hung86126352hung
jag116542712ja_g
jagg136115312jagg
jane115031472jane
kana85928522kana
kane85133962kane
kiang104811352kiang
king95933652king
klong105310402klong
la219261632la__
lab58864782la_b
labs67145122labs
lac510155822la_c
lace66848472lace
lacing94626232lacing
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
lade56345982lade
lading84227122lading
lads56549132lads
lady86527152lady
lags56546222lags
laic65931562laic
laid56439142laid
laigh95515922laigh
lain46146282lain
lair45934152lair
lake85741602lake
lakh114919952lakh
laking115027042laking
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
laming94528362laming
lamp86233822lamp
lams66552262lams
lanai5319572lanai
lance75126722lance
lands65426902lands
lanes54946792lanes
langue71012172langue
langur7109302langur
lanky125517482lanky
lanugo735572lanugo
lap58565272la_p
laps66848872laps
lar37967532la_r
lard56742002lard
large65325462large
largo65319782largo
lari45839152lari
lark85733862lark
lars46956572lars
las37281472la_s
lase46148512lase
lash76539652lash
lasing74727982lasing
lass47444542lass
last46260322last
lat37593402la_t
late47560482late
lath76640382lath
lati46438272lati
lats45962702lats
latu47934182latu
laud56527722laud
laugh94414372laugh
lav66847342la_v
lava76725422lava
lave75642142lave
laving104623572laving
lavs76734152lavs
law68656642la_w
lawing104625282lawing
lawn75925632lawn
lawns85215422lawns
lawny115912012lawny
laws76441682laws
lax107651522la_x
lay68865352la_y
laying104525702laying
lays76043252lays
laze136235052laze
lazing164821472lazing
lazy166423072lazy
lean46345242lean_
leans55536252leans
leant56737782leant
leg46446112l_eg
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
liana53915892liana
liane54720662liane
liangs74410592liangs
lin37967372lin_
line46965572line
linga66820812linga
lingo66022102lingo
lings67135772lings
lingy96925132lingy
link86943442link
linn46034592linn
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
llano5910602llano
loan47436452loan_
loans56026462loans
log46252682l_og
lone45849132lone
longe66626462longe
longs65527062longs
lug46138062l_ug
luna46229852luna
lune47140492lune
lunge65323802lunge
lungi65516052lungi
lungs65223882lungs
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lying95717452lying
lynx1437422lynx
mag67956472ma_g
man57465852man_
mana65341942mana
mane65052012mane
manga85026192manga
mange84930182mange
mango85724312mango
mangy115021232mangy
mano66536792mano
mans66354532mans
many95731842many
nag46450812na_g
nan37854872nan_
nana46632892nana
nans46139392nans
orang65119942orang
pan58466442pan_
pane64950282pane
panga85323532panga
pangs84628662pangs
pans65855722pans
pant66061252pant
ping75943592ping
plan65833942plan_
plane74929142plane
plank115221142plank
plans75731272plans
plant75437112plant
pong76231142pong
prang84820322prang
pung75429632pung
rag45761322ra_g
ragg65622692ragg
ran38266612ran_
rand55839562rand
range64728412range
rangy95320382rangy
rani46640102rani
rank85135522rank
rant45864672rant
ring56541152ring
rung56429972rung
sag46163402sa_g
sand55338462sand
sane45954332sane
sanga66023792sanga
sangh95517452sangh
sank85236822sank
sans45153352sans
sing57544172sing
slag55934352sla_g
slangs75615342slangs
slangy105411392slangy
slank95822772slank
slant55238702slant
sling66028802sling
slung65117832slung
snag55827872snag
song55133672song
spang84919732spang
stang66424682stang
sung55832172sung
swang95519722swang
tag47259492ta_g
tan37167562tan_
tanga64923682tanga
tango66921172tango
tangs65028342tangs
tangy94519932tangy
tank85134012tank
tans46154812tans
ting56139892ting
tong56434352tong
tung55328162tung
twang94511852twang
ulan46527392ulan_
ulans54921302ulans
van66246322van_
vane75534682vane
vangs96319582vangs
vans76236722vans
wag76451752wa_g
wan66761932wan_
wand85833872wand
wane76344712wane
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
whang124813382whang
wing86339222wing
wrang94716112wrang
yag76947732ya_g
yangs95618692yangs
yank115423662yank
zag137539472za_g
zany167316982zany
zing145728612zing

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 Limit298723321.03029001.9
3Display Results3323320.0804150.0
 (SQL Overall)1786913321.186150666.9
 
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.