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

121 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
glazes16531564(None) 
blazes174817351blazes
gazes155425911g_azes
glaces94218021glaces
glades84820341glades
glares75518861glares
glaze155418161glaze_
glazed174711771glazed
glazer164212261glazer
glazers174410041glazers
glozes164313351glozes
grazes164519641grazes
lazes145129571_lazes
alates64833962alates
amazes175613472amazes
blades95221252blades
blames105121862blames
blares85021632blares
blaze165520832blaze_
blazed184314712blazed
blazer174414022blazer
blazers184811682blazers
brazes175522192brazes
clades94920462clades
claves115020062claves
clozes174915562clozes
crazes174720132crazes
dazes155024142_dazes
deglazes1935462deglazes
elates65032362elates
fazes175527212_fazes
feazes184514172feazes
flakes134118872flakes
flames114723692flames
flanes94522422flanes
flares94521702flares
flaxes165015352flaxes
gaes56348032g_a_es
gages74529972g_ages
galaxes1538872galaxes
gales65442482g_ales
games86238552g_ames
gapes86030822g_apes
gases65633992g_ases
gates65939512g_ates
gauzes164710632gauzes
gaze145032412g_aze_
gazed165520332g_azed
gazer155720072g_azer
gazers164516302g_azers
gelates83219582gelates
ghazies2036912ghazies
ghazis1935202ghazis
glace87420152glace_
glacis94012132glacis
glade75121962glade_
glads75620612gla_ds
glaires84010132glaires
glairs75211332glairs
glaives11347832glaives
glams85822932gla_ms
glances104113142glances
glandes95413832glandes
glands85314402glands
glans65125832gla_ns
glare65222952glare_
glared84715192glared
glass65518132gla_ss
glasses84414272glasses
glazier17409352glazier
glaziers18406562glaziers
glaziest18227912glaziest
glazy187410982glaz_y
glebes95512242glebes
gledes84915132gledes
glees65027592gl_ees
glides84518862glides
glimes94717522glimes
glitzes17367562glitzes
globes94314542globes
gloves104115182gloves
gloze154815982gloze_
glozed173711222glozed
glues65125682gl_ues
glumes94516812glumes
glutes74517672glutes
graces94523492graces
grades84926312grades
grapes95123122grapes
grates75429892grates
graves104624002graves
graze155820052graze_
grazed174115912grazed
grazer164815762grazer
grazers175112452grazers
hazes174928322_hazes
laces76141762_laces
lades65141272_lades
lakes95737652_lakes
lames75445542_lames
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
laves86039152_laves
laxes125430092_laxes
laze136235052_laze_
lazed154925842_lazed
lazies154418782_lazies
mazes165632172_mazes
places104323702places
plages94520152plages
planes85028082planes
plates85432242plates
plazas17409912plazas
razes145032702_razes
reglazes1846792reglazes
slakes104021882slakes
slates64934062slates
slaves95023022slaves
sleazes162810332sleazes
smazes174311662smazes

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 Filter178691825510.360496363.9
2DLD Change Limit825511212.51332849.6
3Display Results1211210.0333666.7
 (SQL Overall)1786911212.90661490.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.