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

235 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
glams8582293(None) 
blams95023851blams
clams95127671clams
flams105125011flams
gams76648881g_ams
glads75620611glads
glam76529341glam_
glans65125831glans
glass65518131glass
gleams94812251gleams
glims87417671glims
gloams95210661gloams
gloms85219781gloms
glums84621421glums
grams85327311grams
lams66552261_lams
slams74927901slams
alamo7418142alamo
alamos8415002alamos
alans55636172alans
alarms85913052alarms
alas46358122ala_s
almas76629772almas
alms65834922al_ms
alums75720602alums
balms95723922balms
bams87044452_bams
beams95328172beams
blabs95619632blabs
blahs105616512blahs
blam86131702blam_
blame95625492blame
blames105121862blames
blats75132502blats
blaws105620462blaws
calms95222352calms
cams87047282_cams
chams126028502chams
clads85722732clads
clags85621122clags
claims105211572claims
clam86332292clam_
clamp115517652clamp
clamps124515082clamps
clans75031012clans
claps95626182claps
class75525482class
claws106020832claws
clays105521332clays
crams96229152crams
dams77444372_dams
drams86025832drams
elans55527752elans
elms67322702el_ms
exams14199082exams
flabs105818642flabs
flags95321282flags
flam96333292flam_
flame105124442flame
flames114723692flames
flamy135217472flamy
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flays116321052flays
fleams115011942fleams
foams105017952foams
gabs76740422g_abs
gads67843382g_ads
gaes56348032g_aes
gags66441062g_ags
galahs105512672galahs
galas65731642galas
gales65442482gales
galls64729322galls
gals57946502g_als
gam67060062g_am_
gama77035512g_ama
gamas85431352g_amas
gamb96331842g_amb
gambs105721122g_ambs
game76644322g_ame
games86238552g_ames
gamp98833212g_amp
gamps105323712g_amps
gamy105427532g_amy
gaps76042972g_aps
gars55750742g_ars
gas48870252g_a_s
gats56753442g_ats
gaums86217072gaums
gays87338022g_ays
gears64628692gears
gems75329112g_ems
germs85118872germs
geums85414112geums
ghats95818612ghats
glace87420152glace
glaces94218022glaces
glacis94012132glacis
glad65624012gla_d
glade75121962glade
glades84820342glades
glady105413942glady
glair65313552glair
glairs75211332glairs
glamor958182glamor
glamors1068112glamors
gland75217712gland
glands85314402glands
glare65222952glare
glares75518862glares
glary96018542glary
glassy10527752glassy
glaze155418162glaze
glazes165315642glazes
glazy187410982glazy
gleam86916732gleam_
gleamy12398112gleamy
gleans75014742gleans
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
glias64618492glias
glim76026352glim_
glime85620192glime
glimes94717522glimes
gloam86015942gloam_
gloats74515422gloats
globs85616402globs
glom75424382glom_
glomus9468092glomus
glooms96211682glooms
glops85619552glops
gloss64319622gloss
glows95518032glows
glues65125682glues
glugs75214282glugs
glum75825102glum_
glume85120462glume
glumes94516812glumes
gluts66120132gluts
gnars66718852gnars
gnats65217712gnats
gnaws96311142gnaws
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
golems939322golems
gorms85619592gorms
grabs85719692grabs
grads75625752grads
gram77034582gram_
grama85620282grama
gramas94317202gramas
gramp106218322gramp
gramps114114272gramps
grans64832542grans
grass66125202grass
grays95621332grays
guans64419442guans
guars65021042guars
gulags837542gulags
gums75030942g_ums
gyms107514592g_yms
halms105225212halms
hams96446132_hams
imams91511102imams
jams135231072_jams
kalams12310602kalams
labs67145122_labs
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lam57666712_lam_
lama66635292_lama
lamas75532792_lamas
lamb86832142_lamb
lambs95921412_lambs
lame66849292_lame
lames75445542_lames
lamp86233822_lamp
lamps95624832_lamps
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
lats45962702_lats
lavs76734152_lavs
laws76441682_laws
lays76043252_lays
llama799892llama
llamas888972llamas
loams75619862loams
lums65734242_lums
malms95021552malms
ogams84112682ogams
oghams1245852oghams
palms94921752palms
pams85641762_pams
plans75731272plans
plasm94114632plasm
plasms103711332plasms
plats75531372plats
plays106320772plays
plums94619952plums
prams96125512prams
rams65950772_rams
reams75729622reams
roams74919612roams
scams94423972scams
seams75731662seams
shams105829412shams
slabs75322642slabs
slags66525902slags
slam67737972slam_
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slims75423652slims
slums74623432slums
spams94922192spams
tams67247932_tams
teams75726512teams
trams75327672trams
ulama7711472ulama
ulamas8910452ulamas
ulans54921302ulans
whams135515642whams
yams95330732_yams
ylems1039262ylems

Search took 5 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.250714764.0
2DLD Change Limit538002353.78314221.5
3Display Results2352350.1531535.9
 (SQL Overall)1786912354.18642687.8
 
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.