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

260 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
lamas7553279(None) 
almas76629771almas
amas67746291_amas
camas96333521camas
gamas85431351gamas
lama66635291lama_
lambs95921411lambs
lames75445541lames
lamias85020611lamias
lampas106615951lampas
lamps95624831lamps
lams66552261lam_s
lavas85422221lavas
limas75627631limas
llamas888971llamas
lumas75622911lumas
mamas95930771mamas
ulamas8910451ulamas
aas310975392_a_as
abas68642082_abas
agamas97413442agamas
agas55938842_agas
agmas85919872agmas
alamos8415002alamos
alas46358122_alas
albas75925392albas
alfas87219042alfas
algas65624932algas
alias55834602alias
alma66333022alma_
almah106917252almah
almahs118611612almahs
almes75126542almes
alms65834922alm_s
ama510853302_ama_
amah98927482_amah
amahs107819062_amahs
amass77119682_amass
amias75831472_amias
amis66445322_amis
amps86230342_amps
amus65529612_amus
anas46649862_anas
atmas75721012atmas
baas66844672ba_as
babas96325732babas
balas76937212balas
bams87044452bam_s
bemas96424282bemas
bimas95521742bimas
blames105121862blames
blams95023852blam_s
cacas95627982cacas
camass104114182camass
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282cam_s
casas75327842casas
clamps124515082clamps
clams95127672clam_s
comas95833002comas
cymas126417882cymas
dadas75819862dadas
daman84821162daman
damans94715982damans
damar84117732damar
damars93814992damars
damask1335842damask
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
dramas95814652dramas
dumas85420432dumas
fames105735922fames
favas115618592favas
flames114723692flames
flams105125012flam_s
galas65731642galas
gama77035512gama_
gamay116419102gamay
gamays126310902gamays
gambas115817512gambas
gambs105721122gambs
games86238552games
gammas115714692gammas
gamps105323712gamps
gams76648882gam_s
glams85822932glam_s
gramas94317202gramas
hahas117118442hahas
halmas117017892halmas
hamal104623102hamal
hamals114816812hamals
hames106138702hames
hams96446132ham_s
hamzas20119012hamzas
iambs95815062iambs
jambs166014622jambs
jams135231072jam_s
javas155915422javas
kaas86531842ka_as
kakas85117342kakas
kames115024692kames
kanas95326912kanas
kapas116021732kapas
karmas123013732karmas
katas95922092katas
kavas125919952kavas
labs67145122la_bs
laces76141762laces
lacks116129202lacks
lacs66942482la_cs
lades65141272lades
lads56549132la_ds
lagan66520342lagan
lagans75717782lagans
lags56546222la_gs
lahar83114262lahar
lahars94013162lahars
laics76419252laics
lairs55425872lairs
lakes95737652lakes
lakhs125210342lakhs
lalls55324132lalls
lam57666712lam__
lamb86832142lam_b
lambast11129892lambast
lambdas1246242lambdas
lamby125114842lamby
lame66849292lam_e
lamed85235292lamed
lameds94812032lameds
lamer75233702lamer
lamest84722762lamest
lamia75324322lamia
lamiae84817452lamiae
laminas93615872laminas
lamp86233822lam_p
lampad114510032lampad
lampads12477622lampads
lanai5319572lanai
lanais6316792lanais
lands65426902lands
lanes54946792lanes
lapis76223152lapis
laps66848872la_ps
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572la_rs
larvas9310232larvas
las37281472l__as
lases54944762lases
lass47444542la_ss
lasts57731262lasts
laths86022402laths
lats45962702la_ts
lauan55216792lauan
lauans65113532lauans
lauds65618482lauds
lauras63414332lauras
lava76725422lava_
lavash12597372lavash
laves86039152laves
lavs76734152la_vs
lawman11289052lawman
lawns85215422lawns
laws76441682la_ws
laxes125430092laxes
layman113511302layman
lays76043252la_ys
lazar144113642lazar
lazars153812392lazars
lazes145129572lazes
leas45954182l_eas
leman75622602leman
lemans85316392lemans
lemmas10349162lemmas
lianas63713382lianas
lima65734132lima_
liman75921602liman
limans84816302limans
limbas105313202limbas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limpas105513082limpas
limps95522672limps
liras56021982liras
litas54923772litas
llama799892llama_
loams75619862loam_s
lotas55926302lotas
loumas84812332loumas
luma65527522luma_
lumps95624982lumps
lums65734242lum_s
lunas55025012lunas
magmas115512502magmas
mama86231582mama_
mambas125716242mambas
mammas94616402mammas
manas76240422manas
maras75443282maras
mas58175812__mas
masas75630412masas
mayas105924382mayas
nadas66320812nadas
nalas55528362nalas
names74833362names
nanas55928632nanas
napas75924352napas
nemas75321572nemas
nomas74726412nomas
pacas96029402pacas
pampas124913992pampas
pams85641762pam_s
papas94927492papas
paras76143042paras
pimas94725102pimas
plasmas113010752plasmas
playas114612282playas
plazas17409912plazas
pumas95121562pumas
ragas65326062ragas
raias54631122raias
rajas127317722rajas
ramal74622242ramal
ramps96224632ramps
rams65950772ram_s
ramus76418282ramus
rayas85922052rayas
sagas66025882sagas
sambas104219262sambas
samps96124672samps
shamas113717932shamas
simas75727552simas
slams74927902slam_s
somas76030372somas
takas95520682takas
talas55935892talas
tamal73522612tamal
tamals84116622tamals
tames75242012tames
tamis76728722tamis
tamps95524082tamps
tams67247932tam_s
tapas74627712tapas
ulama7711472ulama_
ulemas888962ulemas
vamps125415482vamps
varas86028192varas
wames106432802wames
wamus105514682wamus
yams95330732yam_s
zamias174212922zamias

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002601.92327977.1
3Display Results2602600.0604333.3
 (SQL Overall)1786912602.07686074.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.