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

186 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
luma6552752(None) 
duma75524451duma
lama66635291lama
lima65734131lima
louma76213631louma
lum55542931lum_
lumas75622911lumas
lump86531701lump
lums65734241lums
luna46229851luna
puma85424121puma
agma77623262agma
alma66333022alma
alula5317092alula
alum65227612alum_
alumna857342alumna
alums75720602alums
ama510853302_ama
atma68121772atma
aura45836252aura
bema85825252bema
bima86723832bima
blume95619892blume
bum75342692bum_
bumf116126512bumf
bump106228242bump
bums85934592bums
buna64730722buna
bura66139532bura
clump115517452clump
coma87134852coma
cum76440162cum_
cyma116715842cyma
douma85817702douma
dumas85420432dumas
dumb97124102dumb
dumka12438832dumka
dump95927092dump
dura55232112dura
flume106021172flume
flump124614722flump
fume96727632fume
fumy127118582fumy
gama77035522gama
glum75825102glum_
glume85120462glume
glums84621422glums
gum67439532gum_
gumma105313102gumma
gums75030942gums
hula74923752hula
hum85542932hum_
human102716032human
hump116228722hump
hums96831422hums
juba134916982juba
juga126417322juga
jump156621722jump
jura116024892jura
kuna85120702kuna
la219261632l__a
lam57666712lam_
lamas75532792lamas
lamb86832142lamb
lame66849292lame
lamia75324322lamia
lamp86233822lamp
lams66552262lams
laura54116202laura
lava76725422lava
lea37660182l_ea
leman75622602leman
lemma94811032lemma
leva77020712leva
liman75921602liman
limas75627632limas
limb85429382limb
limba95414982limba
lime66244932lime
limn66527692limn
limo65529732limo
limp88432492limp
limpa97014462limpa
limy95727712limy
lipa68425922lipa
lira46928682lira
llama799892llama
loam65630482loam
loca65527682loca
lota47233502lota
loumas84812332loumas
luau44824162luau
lube64731562lube
luce65132572luce
luck105329822luck
lude55331642lude
lues45943552lues
luff104426702luff
luffa11409022luffa
lug46138062lu_g
luge55531642luge
lugs55233522lugs
lull44225762lull
lulu44122882lulu
lumbar103610592lumbar
lumen75220902lumen
lumina84613542lumina
lumps95624982lumps
lumpy126615912lumpy
lunar57017312lunar
lunas55025012lunas
lune47140492lune
lung55732492lung
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lure45142462lure
lurk86624162lurk
lush75327692lush
lust47442602lust
lute46341012lute
lutea54819072lutea
lutz136826322lutz
luv67125772lu_v
luvs75818502luvs
lux106528772lu_x
luxe115222692luxe
ma410060662__ma
mama86231592mama
mum76643612mum_
mumm75718862mumm
mump105425722mump
mums85732772mums
mumu86022062mumu
mura65633302mura
nema65522522nema
noma67529462noma
numb85520612numb
pima85428652pima
plum85122102plum_
plumb114514072plumb
plume94819462plume
plump115315262plump
plums94619952plums
plumy124213232plumy
puja135714922puja
pula65129372pula
pumas95121562pumas
pump105726852pump
puna65331652puna
pupa85422812pupa
qua124821972qu_a
ruga56121232ruga
rum56644642rum_
rumba93612512rumba
rump86729082rump
rums64833472rums
sima64730782sima
slum65430512slum_
slump94816632slump
slums74623432slums
soma65635292soma
suba64926602suba
sum56346012sum_
sumac99514882sumac
summa94713312summa
sumo67326312sumo
sump86331532sump
sums65837582sums
sura45740292sura
tuba65422362tuba
tufa75016612tufa
tump85927032tump
tuna45127842tuna
ulama7711472ulama
ulema7109712ulema
ulna46317332ulna
ulva75412692ulva
um47338832_um_
umm711921262_umm
ump76130442_ump
uta37425582_uta
vum85428652vum_
yuca95716722yuca
yuga85615422yuga
yum86132822yum_

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.280638182.1
2DLD Change Limit298721860.87634100.5
3Display Results1861860.0464043.5
 (SQL Overall)1786911861.202148661.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.