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

486 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
lame6684929(None) 
alme65832161alme
blame95625491blame
came87648751came
dame77140311dame
fame95639391fame
flame105124441flame
game76644321game
hame97043131hame
kame105728231kame
lace66848471lace
lade56345981lade
lake85741601lake
lam57666711lam_
lama66635291lama
lamb86832141lamb
lamed85235291lamed
lamer75233701lamer
lames75445541lames
lamp86233821lamp
lams66552261lams
lane45153321lane
lase46148511lase
late47560481late
lave75642141lave
laze136235051laze
lime66244931lime
name65637411name
same65245641same
tame66343661tame
wame95035481wame
ace59656832_ace
acme86924322acme
ae212590292_a_e
aflame1138722aflame
age47154332_age
alae45643752alae
alamo7418142alamo
alane56135612alane
alate55340322alate
ale36572342_ale
alee46652322alee
alma66333022alma
almeh106214552almeh
almes75126542almes
alms65834922alms
aloe45540192aloe
am411875562_am_
ama510853302_ama
amen66733152_amen
ami56646812_ami
amie66339852_amie
amp77541022_amp
amu58237322_amu
ane37866942_ane
ape57251182_ape
arame75026622arame
are37874572_are
ate37059242_ate
ave67748702_ave
awe67746622_awe
axe108239492_axe
aye67151762_aye
babe86835822babe
bade75140882bade
bake105637512bake
bale66353842bale
bam78560142bam_
bams87044452bams
bane65250422bane
bare65460522bare
base64847022base
bate66552422bate
blade85923332blade
blae66134642bla_e
blam86131702blam_
blamed116017952blamed
blamer104417142blamer
blames105121862blames
blams95023852blams
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
blume95619892blume
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
cam78058982cam_
camel96822802camel
cameo95924992cameo
cames97047312cames
camo85731752camo
camp106336452camp
cams87047282cams
cane66653112cane
cape87242782cape
care66968372care
case65848082case
cate66254592cate
cave95941262cave
clade85821012clade
clam86332292clam_
clamp115517652clamp
clams95127672clams
clave105420152clave
clime95720892clime
come87547702come
cyme119420372cyme
dace76934922dace
dale55643982dale
dam67457042dam_
dames85435852dames
damn75724322damn
damp96228842damp
dams77444372dams
dare55848862dare
date56443322date
daze147327232daze
deme76536282deme
dime76237642dime
dome77240732dome
ease45042332ease
eave75733582eave
elate55335882elate
eme55837182_eme
face96140122face
fade85736342fade
fake115534942fake
famed115928342famed
fames105735922fames
fane75343562fane
fare76354462fare
fate75444282fate
fave105532962fave
faze165630042faze
feme96130542feme
flake125119972flake
flam96333292flam_
flambe13489152flambe
flamed124618972flamed
flamen115215992flamen
flamer114919122flamer
flames114723692flames
flams105125012flams
flamy135217472flamy
flare84823632flare
flume106021172flume
frame105821802frame
fume96727632fume
gae46457702ga_e
gage65936102gage
gale56347322gale
gam67060062gam_
gama77035512gama
gamb96331842gamb
gambe106219212gambe
gamed95126392gamed
gamer84928942gamer
games86238552games
gamey115320552gamey
gamp98833212gamp
gams76648882gams
gamy105427532gamy
gane55145292gane
gape75134512gape
gate55746572gate
gave84634052gave
gaze145032412gaze
glace87420152glace
glade75121962glade
glam76529342glam_
glams85822932glams
glare65222952glare
glaze155418162glaze
glime85620192glime
glume85120462glume
hade85440192hade
hae67364002ha_e
haem95730982haem
hake115637842hake
hale76052832hale
ham86363282ham_
hames106138702hames
hams96446132hams
hare76255732hare
hate78450172hate
have106137072have
haze164833392haze
heme95034412heme
home98042442home
iamb86623732iamb
jade125325442jade
jake155925772jake
jam126942522jam_
jamb155523852jamb
jambe165314752jambe
jams135231072jams
jane115031472jane
jape134923422jape
kae76744542ka_e
kale86533752kale
kames115024692kames
kami105823642kami
kane85133962kane
la219261632la__
lab58864782la_b
label75019382label
labs67145122labs
lac510155822la_c
laced87132642laced
lacer75833752lacer
laces76141762laces
lacey105820912lacey
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
laded74232612laded
laden65022192laden
lader65633722lader
lades65141272lades
ladle66320442ladle
lads56549132lads
lady86527152lady
lag47862122la_g
lager65132862lager
lags56546222lags
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
laked105731122laked
laker95432872laker
lakes95737652lakes
lakh114919952lakh
laky116725822laky
lall45531312lall
lamas75532792lamas
lambed115614782lambed
lamber104418492lamber
lambie103213672lambie
lambs95921412lambs
lamby125114842lamby
lamedh12476362lamedh
lameds94812032lameds
lamely114013222lamely
lament85024942lament
lamest84722762lamest
lamia75324322lamia
lamiae84817452lamiae
lammed113915622lammed
lamped114017542lamped
lamps95624832lamps
lance75126722lance
land56337302land
lanes54946792lanes
lang56637372lang
lank84734442lank
lap58565272la_p
lapel73716682lapel
laps66848872laps
lapse74917682lapse
lar37967532la_r
lard56742002lard
laree56036292laree
lares54852632lares
large65325462large
lari45839152lari
lark85733862lark
lars46956572lars
las37281472la_s
lased65132342lased
laser54633322laser
lases54944762lases
lash76539652lash
lass47444542lass
last46260322last
lat37593402la_t
lated65240672lated
laten54328342laten
later54843922later
latex124717112latex
lath76640382lath
lathe85626712lathe
lati46438272lati
latke94817092latke
lats45962702lats
latte55426302latte
latu47934182latu
laud56527722laud
lav66847342la_v
lava76725422lava
laved95028592laved
laver85031792laver
laves86039152laves
lavs76734152lavs
law68656642la_w
lawed96028322lawed
lawmen11308592lawmen
lawn75925632lawn
laws76441682laws
lax107651522la_x
laxer125420332laxer
laxes125430092laxes
lay68865352la_y
layed95127382layed
layer84626472layer
laymen113010842laymen
lays76043252lays
lazed154925842lazed
lazes145129572lazes
lazy166423072lazy
lease55230262lease
leave84723722leave
lee36068142l_ee
leke85527402leke
liane54720662liane
lice66045062lice
lie38264522l_ie
life75433732life
like86040842like
lima65734132lima
limb85429382limb
limed85426802limed
limen75426032limen
limes75636502limes
limey104721042limey
limn66527692limn
limo65529732limo
limp88432492limp
limy95727712limy
line46965572line
lipe66839732lipe
lire47845292lire
lite47054542lite
live76540992live
llama799892llama
loam65630482loam_
loamed94414612loamed
loams75619862loams
loamy105913342loamy
lobe65535362lobe
lode56240112lode
loge56837192loge
lone45849132lone
lope65941922lope
lore45850352lore
lose45144582lose
love75234762love
lowe75435312lowe
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lum55542932lum_
luma65527522luma
lumen75220902lumen
lump86531702lump
lums65734242lums
lune47140492lune
lure45142462lure
lute46341012lute
luxe115222692luxe
lyase85512412lyase
lye66533412l_ye
lyre75623792lyre
lyse76320592lyse
mabe85733352mabe
mace87345782mace
made75440232made
mae57659102ma_e
mage75739122mage
make105537882make
male66052292male
mama86231582mama
mamey125418832mamey
mamie95826002mamie
mane65052012mane
mare64759322mare
mate65154212mate
maze155434972maze
me47748332__me
meme85330552meme
mime85736402mime
mome85239352mome
nabe66029492nabe
nae35952742na_e
nam55953392nam_
named85223062named
namer75622102namer
names74833362names
nape65230802nape
nave75732312nave
nome66038422nome
pace86345772pace
page76036102page
pale66055012pale
pam77858392pam_
pams85641762pams
pane64950282pane
pare66760842pare
pase65346862pase
pate65350462pate
pave96133892pave
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
plume94819462plume
pome85636692pome
race66746262race
rage55742352rage
rake84841572rake
rale45050562rale
ram56867272ram_
ramee74633852ramee
ramen75625192ramen
ramet75743142ramet
rami66034092rami
ramie75027822ramie
ramp85934002ramp
rams65950772rams
rape65041632rape
rare45348432rare
rase46149982rase
rate45458762rate
rave75542092rave
raze135235432raze
rime65138882rime
sabe66140572sabe
sade55544472sade
sae38365182sa_e
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
samek114915272samek
samp85733592samp
sane45954332sane
sate45556102sate
save75741362save
seme65836652seme
shame105726702shame
slake93724052slake
slam67737972slam_
slams74927902slams
slate55438282slate
slave84224032slave
slime74925752slime
some66040382some
tace65342512tace
tae38267052ta_e
take84739262take
tale46154162tale
tam58663422tam_
tamed85528512tamed
tamer75230102tamer
tames75242012tames
tamp86133002tamp
tams67247932tams
tape64538142tape
tare45957622tare
tate44748602tate
time66235012time
tome67543192tome
ulama7711472ulama
vale74937342vale
vamp115521542vamp
vane75534682vane
vase75629652vase
wade85237062wade
wae67556952wa_e
wage84834082wage
wake114935702wake
wale74546432wale
wames106432802wames
wane76344712wane
ware76254722ware
wave105234732wave
yam87448992yam_
yamen104115182yamen
yams95330732yams
yare75636942yare
zyme1819114942zyme

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 Limit298724861.05028449.5
3Display Results4864860.1233951.2
 (SQL Overall)1786914861.249143067.3
 
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.