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

177 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
gazers16451630(None) 
gagers84021331gagers
gamers94420831gamers
gapers94520471gapers
gaters74728641gaters
gazars164811551gazars
gazer155720071gazer_
gazes155425911gaze_s
glazers174410041glazers
grazers175112451grazers
hazers184615951hazers
mazers173917091mazers
razers154919611razers
agers65027852_agers
aggers85817792aggers
apers76629132_apers
avers85127312_avers
bakers125323452bakers
balers85626932balers
bazars174613112bazars
blazers184811682blazers
brazers184513942brazers
cabers105023922cabers
cagers95624192cagers
caners84629202caners
capers105428142capers
carers85133962carers
caters85336502caters
cavers115026842cavers
darers75921872darers
daters74827372daters
dazes155024142daze_s
dozers164815422dozers
eagers74523682eagers
eaters65535952eaters
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
fazes175527212faze_s
gabbers124612832gabbers
gadders103611502gadders
gaes56348032ga_e_s
gaffers14428712gaffers
gager74726292gager_
gages74529972gage_s
gaggers103413662gaggers
gainers84214592gainers
gaiters83516542gaiters
galeas74618512galeas
galere73716682galere
galeres83514342galeres
gales65442482gale_s
gamer84928942gamer_
games86238552game_s
gammers123214562gammers
ganders93521702ganders
ganefs10489202ganefs
ganevs10456912ganevs
gangers94418602gangers
gaolers83511562gaolers
gaper86125122gaper_
gapes86030822gape_s
garners83815982garners
gars55750742ga__rs
garters84218232garters
gases65633992gase_s
gaspers105014132gaspers
gassers84714632gassers
gasters85624292gasters
gater64533652gater_
gates65939512gate_s
gathers114315072gathers
gators74115842gators
gaugers94211712gaugers
gaurs66317992ga_urs
gauzes164710632gauze_s
gavels105911092gavels
gawkers15347452gawkers
gawpers13448312gawpers
gayer94519192gayer_
gazar154612982gazar_
gaze145032412gaze__
gazebo1833672gazebo
gazebos1933492gazebos
gazed165520332gaze_d
gazoos163010222gazoos
geezers17286512geezers
gibers95114662gibers
givers104817712givers
glazer164212262glazer_
glazes165315642glaze_s
glaziers18406562glaziers
gluers75011152gluers
gnawers11356392gnawers
goers65520252g_oers
gofers104711512gofers
gomers94116882gomers
goners74420172goners
graders94716012graders
graters85419742graters
gravers114515272gravers
grazer164815762grazer_
grazes164519642graze_s
graziers18387122graziers
halers94926912halers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazels185710082hazels
hazer174820232hazer_
hazes174928322haze_s
jagers144415722jagers
japers154616172japers
jazzers22324762jazzers
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
lazars153812392lazars
lazes145129572laze_s
macers105321272macers
makers123921732makers
mamzers20409162mamzers
masers84623452masers
maters85032392maters
mazer165722422mazer_
mazes165632172maze_s
namers84517332namers
oaters65029792oaters
pacers105124542pacers
pagers94423252pagers
panzers184012012panzers
papers105125322papers
parers85530742parers
paters84935832paters
patzers184210572patzers
pavers115021822pavers
pawers114818782pawers
payers114621822payers
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razees154314762razees
razer144824272razer_
razes145032702raze_s
razors154711662razors
sabers85224732sabers
sakers104125432sakers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
sizers155215812sizers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
yagers105114532yagers
zazens1435832zazens

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.326548131.9
2DLD Change Limit825511772.17337989.4
3Display Results1771770.0602950.0
 (SQL Overall)1786911772.55969828.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.