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 “glaziers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

265 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
glaziers1840656(None) 
glaciers11277891glaciers
glazers174410041glaz_ers
glazier17409351glazier_
glaziery21413691glaziery
graziers18387121graziers
blazers184811682blaz_ers
braziers19397192braziers
claviers1367102claviers
gazers164516302g_az_ers
ghazies2036912ghazie_s
glacier103911292glacier_
gladier93810992gladier_
glaires84010132gla_ires
glairs75211332gla_i_rs
glancers11408002glancers
glanders103811502glanders
glarier84112202glarier_
glazer164212262glaz_er_
glazes165315642glaz_e_s
glazieries2043572glazieries
glaziest18227912glaziest
glaziness1935752glaziness
glazings19325752glazings
grazers175112452graz_ers
grazier173611132grazier_
lazier154214612_lazier_
lazies154418782_lazie_s
blabbers11308153blabbers
bladders12397803bladders
bladers104214683bla_ders
blamers115314213bla_mers
blasters104116143blasters
blathers134713793blathers
blatters104414093blatters
blazer174414023blaz_er_
blazes174817353blaz_e_s
blazoners2043863blazoners
brasiers103710513brasiers
brazers184513943braz_ers
brazier183911473brazier_
cahiers123510673_cahiers
clabbers14359903clabbers
clackers163911703clackers
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clampers143211893clampers
clangers114312343clangers
clappers143310833clappers
claquers19226203claquers
claries93422203clarie_s
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
clavers124314903cla_vers
clavier1239173clavier_
clawers123910973cla_wers
clayier1248323clayier_
crazier183610743crazier_
crazies183413853crazie_s
croziers19287003croziers
dalliers93610613dalliers
elaters74420193ela_ters
flaggers13328073flaggers
flairs95711913fla_i_rs
flakers143613273fla_kers
flakier143910203flakier_
flamers124616363fla_mers
flamier123112143flamier_
flangers123311373flangers
flankers15349303flankers
flappers15388383flappers
flashers143912653flashers
flatters113814203flatters
flawier13378733flawier_
flaxier17337983flaxier_
flayers133912033fla_yers
fliers94417193fl__iers
flytiers14254483flytiers
gabbers124612833g_abbers
gabies93820733g_abie_s
gadders103611503g_adders
gaffers14428713g_affers
gagers84021333g_a_gers
gaggers103413663g_aggers
gainers84214593g_ainers
gaiters83516543g_aiters
galabiehs1542443galabiehs
galaxies1637163galaxie_s
gallies84122713gallie_s
gambiers13337073gambiers
gamers94420833g_a_mers
gamier93617933g_amier_
gammers123214563g_ammers
ganders93521703g_anders
gangers94418603g_angers
gaolers83511563g_aolers
gapers94520473g_a_pers
garners83815983g_arners
garters84218233g_arters
gasaliers1044513gasaliers
gaspers105014133g_aspers
gassers84714633g_assers
gasters85624293g_asters
gaters74728643g_a_ters
gathers114315073g_athers
gaugers94211713g_augers
gauzier1735633gauzier_
gawkers15347453g_awkers
gawpers13448313g_awpers
gazars164811553g_az_ars
gazer155720073g_az_er_
gazes155425913g_az_e_s
geezers17286513geez_ers
ghazis1935193ghazi__s
glaces94218023gla_ce_s
glaciered1343863glaciered
glacis94012133glaci__s
glacises1138503glacises
gladdens11364463gladdens
gladder10398313gladder_
glades84820343gla_de_s
gladiest101710333gladiest
gladlier1034343gladlier_
gladness1036153gladness
glair65313553gla_i_r_
glaire74411293gla_i_re
glaired9387743gla_ired
glairier944833glairier_
glairy10448273gla_i_ry
glaives11347833gla_ives
glamors1068113gla_mors
glamours1184733glamours
glancer103710073glancer_
glances104113143glance_s
glandes95413833glande_s
glares75518863gla_re_s
glariest92012523glariest
glariness1038553glariness
glasses84414273glasse_s
glassier9289083glassier_
glassies94012273glassie_s
glaze155418163glaz_e__
glazed174711773glaz_e_d
glazily2035383glazi_ly
glazing183611003glazi_ng
gleamers11306563gleamers
gleamier1144913gleamier_
gleaners9348073gleaners
gliders94811843gl_iders
glimmers13396153glimmers
glisters93912603glisters
glitters93710543glitters
glitzier1833593glitzier_
gloaters9288863gloaters
glories81915913glorie_s
glossers9319053glossers
glovers114310883gl_overs
glowers113412093gl_owers
glozes164313353gloz_e_s
gluers75011153gl__uers
gluier7310263gl_uier_
gnawers11356393gna_wers
goalies8316023goalie_s
grabbers13337883grabbers
graders94716013gra_ders
grafters12409193grafters
grainers93012073grainers
grangers103011973grangers
granters93614143granters
grapier103712603grapier_
graspers11338403graspers
graters85419743gra_ters
gravers114515273gra_vers
gravies11314093gravie_s
grazer164815763graz_er_
grazes164519643graz_e_s
grazings19337263grazings
guarders1035883guarders
guzzlers17274863guzzlers
hazers184615953_haz_ers
hazier184712403_hazier_
jazzers22324763_jazzers
klezmers2341583klezmers
laagers83411253_laagers
lacers85225253_la_cers
lacier84020093_lacier_
lackers134120543_lackers
ladders94115173_ladders
laders74927763_la_ders
ladies75124883_ladie_s
ladlers84613563_ladlers
lagers74826143_la_gers
laggers94216243_laggers
lairs55425873_la_i_rs
lakers105225153_la_kers
lakier104716273_lakier_
lambers113817113_lambers
lampers113817333_lampers
lancers93616643_lancers
lanciers10308543_lanciers
landers84026213_landers
lanners73618333_lanners
lappers113717463_lappers
lapsers93911053_lapsers
larders83516943_larders
larkers113014513_larkers
lasers64925703_la_sers
lashers104121833_lashers
lasters75627693_lasters
lathers104321883_lathers
lauders84012893_lauders
laveers10329363_laveers
lavers94526363_la_vers
lawyers13377153_lawyers
layers93921183_la_yers
lazars153812393_laz_ars
lazes145129573_laz_e_s
lazied164610653_lazie_d
laziest163814473_laziest
laziness17239983_laziness
leviers103510343_leviers
liers55130403_l__iers
liviers104211073_liviers
mazers173917093_maz_ers
mazier175013063_mazier_
paniers94717333_paniers
placers114515263pla_cers
plaguers11286503plaguers
plaiters103512633plaiters
planers94517943pla_ners
planners10399933planners
planters102915323planters
plashers133813453plashers
plasters103518133plasters
platers93924093pla_ters
platier93716293platier_
platies93722543platie_s
platters103415283platters
players124313763pla_yers
pliers84715153pl__iers
ralliers84010833ralliers
rapiers95012873_rapiers
razers154919613_raz_ers
salliers83613343salliers
saltiers83411953saltiers
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slanders94014013slanders
slappers123710943slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slatier74016813slatier_
slavers103716503sla_vers
slayers104513323sla_yers
sleazier1735123sleazier_
talliers83711373talliers
uglifiers1343093uglifiers
variers103712663_variers
viziers19336203_viziers

Search took 7 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461622656.19023612.6
3Display Results2652650.0932849.5
 (SQL Overall)1786912656.43627764.3
 
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.