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

188 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
alma6633302(None) 
agma77623261agma
ala312463601al_a
alba68328331alba
alfa77624271alfa
alga57927601alga
almah106917251almah
almas76629771almas
alme65832161alme
alms65834921alms
ama510853301a_ma
atma68121771atma
halma108219251halma
lama66635291lama
aa219179952a__a
aba512850952a_ba
abba810522652abba
aboma91114602aboma
acme86924322acme
acta69524802acta
adman84517902adman
aga410447232a_ga
agama85815582agama
agha87417302agha
agmas85919872agmas
aha611246642a_ha
aim57858212aim_
aims67738182aims
al210674042al__
alae45643752alae
alamo7418142alamo
alan46844082alan
alar46340072alar
alas46358122alas
alb57342652al_b
albas75925392albas
albs68628572albs
ale36572342al_e
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
alfas87219042alfas
algae65319622algae
algal66518222algal
algas65624932algas
alias55834602alias
alif76242142alif
alit46155692alit
aliya83713482aliya
alky115920342alky
all36148232al_l
allay85620392allay
alls46740922alls
ally76935642ally
almahs118611612almahs
almeh106214552almeh
almes75126542almes
almud84012182almud
almug8429302almug
aloe45540192aloe
aloha8513612aloha
alow75328592alow
alp56641132al_p
alpha1049652alpha
alps65529242alps
als36663022al_s
also46423442also
alt36467962al_t
altar55520642altar
alto47831262alto
alts46639902alts
alula5317092alula
alum65227612alum
alumna857342alumna
alums75720602alums
alway116113922alway
am411875562a_m_
amah98927492a_mah
amas67746292a_mas
ami56646812a_mi
amia66836902amia
ammo85520132ammo
amp77541022a_mp
amu58237322a_mu
ana39559832a_na
anga56831352anga
anima74620072anima
anna45529012anna
anoa45634472anoa
ansa45927772ansa
anta46839582anta
aqua132813962aqua
area45843392area
aria46245422aria
arm58449622arm_
arms66137492arms
army96624182army
aroma71220142aroma
asea46327182asea
atman75520142atman
atmas75721012atmas
aura45836252aura
ava610139322a_va
awa611939672a_wa
axman144813182axman
balm85534202balm_
balms95723922balms
balmy125217472balmy
balsa77920412balsa
bema85825252bema
bima86723832bima
blam86131702blam
calla74827072calla
calm85032362calm_
calms95222352calms
clam86332292clam
coma87134852coma
cyma116715842cyma
dolma86214172dolma
duma75524452duma
elm57531742elm_
elms67322702elms
elmy95616792elmy
flam96333292flam
flea75628492flea
gala55635162gal_a
galea64722932galea
gama77035522gama
gamma106116102gamma
glam76529342glam
glia56423152glia
halm95834972halm_
halmas117017892halmas
halms105225212halms
halva115414432halva
ilea45931462ilea
ilia46026822ilia
ilka87215152ilka
kalam11315112kalam
kalmia1238892kalmia
kalpa114512192kalpa
karma113415002karma
la219261632_l_a
lam57666712lam_
lamas75532792lamas
lamb86832142lamb
lame66849292lame
lamia75324322lamia
lamp86233822lamp
lams66552262lams
lava76725422lava
lea37660182_lea
lima65734132lima
llama799892llama
luma65527522luma
ma410060662__ma
magma104513572magma
malm85129982malm_
malms95021552malms
malmy124816342malmy
mama86231592mama
mamma86317912mamma
nala46930392nal_a
nema65522522nema
noma67529462noma
olea46532722olea
olla44821172olla
palea75028662palea
palm85331362palm_
palmar104113462palmar
palms94921752palms
palmy126016732palmy
pima85428652pima
plea66830602plea
puma85424122puma
salmi7815862salmi
salpa75018352salpa
salsa56718922salsa
sima64730782sima
slam67737972slam
soma65635292soma
tala45938052tal_a
ulama7711472ulama
ulema7109712ulema
ulna46317332ulna
ulva75412692ulva
walla85321032walla

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.283631417.0
2DLD Change Limit298721880.89033564.0
3Display Results1881880.0464087.0
 (SQL Overall)1786911881.219146588.2
 
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.