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

508 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
glanders10381150(None) 
ganders93521701g_anders
glancers11408001glancers
glandes95413831glande_s
landers84026211_landers
slanders94014011slanders
banders104324562_banders
bilanders1235962bilanders
bladders12397802bladders
bladers104214682bla_ders
blander103715162blander_
blenders115210992blenders
blinders113911142blinders
blunders113911332blunders
branders114313092branders
clangers114312342clangers
colanders1238012colanders
danders93921182_danders
flangers123311372flangers
flankers15349302flankers
flinders12439262flinders
gadders103611502g_adders
gander84322762g_ander_
gangers94418602g_angers
genders93616782g_enders
glaciers11277892glaciers
gladdens11364462gladdens
gladder10398312gladder_
glades84820342gla_de_s
gladness1036152gladness
glancer103710072glancer_
glances104113142glance_s
glandered1236332glandered
glandless1134162glandless
glands85314402gland__s
glazers174410042gla_zers
glaziers18406562glaziers
gleaners9348072glean_ers
gliders94811842gl_iders
graders94716012gra_ders
grandees103211282grandees
grander93315872grander_
grandeurs11335112grandeurs
grangers103011972grangers
granters93614142granters
grinders103410422grinders
guarders1035882guarders
handers114224332_handers
inlanders1036142inlanders
islanders1035282islanders
ladders94115172_ladders
laders74927762_la_ders
lancers93616642_lancers
lander74028482_lander_
landlers94312832_landlers
lanners73618332_lanners
larders83516942_larders
lauders84012892_lauders
launders9358742_launders
lenders84419642_lenders
malanders1237022malanders
meanders1168832meanders
oleanders1035572oleanders
panders103423732_panders
planers94517942plan_ers
planners10399932planners
planters102915322planters
plunders11329822plunders
sanders84025942_sanders
slander84015442slander_
solanders1036962solanders
standers93514302standers
uplanders1234852uplanders
wanders114221332_wanders
zanders173015792_zanders
adders84315703__adders
aiders74524633__aiders
alands75418373aland__s
alders74218423__alders
alexanders1842443alexanders
aliners74717723alin_ers
almners9399563almn_ers
amenders11288353amenders
angers75222543__angers
auslanders1143363auslanders
awarders1245073awarders
balancers1345063balancers
bander93928223_bander_
bangers104020353_bangers
bankers133919093_bankers
banners94018713_banners
banters94623113_banters
beaders104120183bea_ders
benders104021063_benders
bilander1136673bilander_
binders103920743_binders
blabbers11308153blabbers
bladder11429153bladder_
bladdery15344583bladdery
blader93618583bla_der_
blades95221253bla_de_s
blamers115314213bla_mers
blanchers16307433blanchers
blandest113811043blandest
blandness1235973blandness
blanker134612023blanker_
blankets14356503blankets
blasters104116143blasters
blathers134713793blathers
blatters104414093blatters
blazers184811683bla_zers
bleeders11448453bleeders
blender104613843blender_
blendes104713683blende_s
blinder103912983blinder_
blinkers14388503blinkers
blonder104011943blonder_
blondes104213163blonde_s
blunder103813143blunder_
blungers11469843blungers
boarders11408623boarders
bonders104120663_bonders
bounders114314113bounders
braiders114110573braiders
brander103915823brander_
branners104010923branners
calenders1237403calenders
cancers114018583_cancers
candlers114214103_candlers
candors104216763_candors
caners84629203_can_ers
cankers134418753_cankers
canners93822663_canners
canoers94318373_canoers
canters94827733_canters
carders104820353_carders
chancers154313493chancers
chandlers15387673chandlers
changers144313203changers
chanters134016743chanters
cinders104617763_cinders
clabbers14359903clabbers
clackers163911703clackers
clades94920463cla_de_s
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clampers143211893clampers
clanger104113493clanger_
clangors11417003clangors
clappers143310833clappers
claquers19226203claquers
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
clavers124314903cla_vers
claviers1367103claviers
clawers123910973cla_wers
cleaners103610543clean_ers
cleansers11335063cleansers
clingers113810663clingers
clinkers14339833clinkers
cloners94514823clon_ers
clowders14357473clowders
clunkers14327553clunkers
colander1139033colander_
cylinders1543203cylinders
dancers103413093_dancers
dander811222993_dander_
dandlers103912053_dandlers
dangers94818213_dangers
daunders10278473daunders
demanders13247573demanders
elands74914773eland__s
elaters74420193ela_ters
elders74817303el__ders
eluders8409903el_uders
emenders11319033emenders
enders74324053__enders
evaders1136933eva_ders
expanders19125093expanders
faders105117463_fa_ders
fanners103914653_fanners
fenders113717263_fenders
finders113717873_finders
flaggers13328073flaggers
flakers143613273fla_kers
flamers124616363fla_mers
flanes94522423flan_e_s
flaneurs1133953flaneurs
flanger113412623flanger_
flanges113413273flange_s
flanker143911293flanker_
flannels1134843flannels
flappers15388383flappers
flashers143912653flashers
flatters113814203flatters
flaunters1234513flaunters
flayers133912033fla_yers
flensers1135463flensers
flinder11319873flinder_
flingers123410193flingers
flooders12257833flooders
flounders1374613flounders
flunkers15347533flunkers
founders123911673founders
frankers15348353frankers
funders113813933_funders
gabbers124612833g_abbers
gadder93714713g_adder_
gaffers14428713g_affers
gagers84021333g_a_gers
gaggers103413663g_aggers
gainers84214593g_ainers
gaiters83516543g_aiters
gamers94420833g_a_mers
gammers123214563g_ammers
gandered112211173g_andered
ganefs10489203g_an_efs
ganevs10456913g_an_evs
ganger83721463g_anger_
gannets83811443g_annets
gaolers83511563g_aolers
gapers94520473g_a_pers
gardens93312093g_ardens
garners83815983g_arners
garters84218233g_arters
gaspers105014133g_aspers
gassers84714633g_assers
gasters85624293g_asters
gaters74728643g_a_ters
gathers114315073g_athers
gaudery1234743g_audery
gaugers94211713g_augers
gawkers15347453g_awkers
gawpers13448313g_awpers
gaydars1235803g_aydars
gazers164516303g_a_zers
gelders93812573g_elders
gender83517933g_ender_
germanders1444603germanders
giantess933893giantess
gilders94212463g_ilders
gingers94118643g_ingers
ginners84314223g_inners
girders9379943g_irders
glaces94218023gla_ce_s
glacier103911293glacier_
gladded11357453gladde_d
gladden10376313gladde_n
gladdeners1352063gladdeners
gladdest11145843gladdest
glade75121963gla_de__
gladier93810993gladier_
glads75620613gla_d__s
glaires84010133glaire_s
glairs75211333gla__irs
glaives11347833glaive_s
glamors1068113gla_mors
glamours1184733glamours
glance94312313glance__
glanced11439233glance_d
gland75217713gland___
glandule1043853glandule
glandules1144253glandules
glans65125833glan___s
glares75518863gla_re_s
glarier84112203glarier_
glasses84414273glasse_s
glazer164212263gla_zer_
glazes165315643gla_ze_s
glazier17409353glazier_
glaziery21413693glaziery
gleamers11306563gleamers
gleaner8379773glean_er_
gledes84915133gl_ede_s
glider84614263gl_ider_
glides84518863gl_ide_s
glimmers13396153glimmers
glisters93912603glisters
glitters93710543glitters
gloaters9288863gloaters
glossers9319053glossers
glovers114310883gl_overs
glowers113412093gl_owers
gluers75011153gl__uers
gnawers11356393gna_wers
goners74420173g_on_ers
goosanders1242863goosanders
grabbers13337883grabbers
grader84919693gra_der_
grades84926313gra_de_s
grafters12409193grafters
grainers93012073grainers
grandads1136553grandads
grandams1237123grandams
grandee93115513grande_e
grandest10311573grandest
grandeur10305673grandeur
grandmas1236923grandmas
grandness1138303grandness
grandpas1236003grandpas
grands84218243grand__s
grandsirs1144553grandsirs
granger93514213granger_
granges93516523grange_s
grantees92510973grantees
granter84117133granter_
grantors93810353grantors
graspers11338403graspers
graters85419743gra_ters
gravers114515273gra_vers
grazers175112453gra_zers
graziers18387123graziers
gridders11286293gridders
grinder93312393grinder_
grindery13255513grindery
grinners9288043grinners
groaners9248503groan_ers
grounders1156783grounders
grungers10298503grungers
grunters9359033grunters
guarder936463guarder_
guiders94111113g_uiders
guilders1035513guilders
gunners83111733g_unners
hander104526433_hander_
handlers124014143_handlers
hangers113120813_hangers
hankers144218133_hankers
headers113819393hea_ders
highlanders1952023highlanders
hinders113718503_hinders
hoarders12307433hoarders
hounders123111713hounders
inlander937223inlander_
islander946103islander_
joinders16337203joinders
laagers83411253_laagers
lacers85225253_la_cers
lackers134120543_lackers
ladder84617623_ladder_
ladens74516233_la_dens
lader65633723_la_der_
lades65141273_la_de_s
ladlers84613563_ladlers
lagers74826143_la_gers
laggers94216243_laggers
lakers105225153_la_kers
lambers113817113_lambers
lampers113817333_lampers
lancer84319973_lancer_
lances84824103_lance_s
lancets93411163_lancets
lanciers10308543_lanciers
landaus8310343_landaus
landed84619243_lande_d
landler84113203_landler_
landless94011173_landless
lands65426903_land__s
lanes54946793_lan_e_s
langurs889103_langurs
lanker104123003_lanker_
lanner64920603_lanner_
lantern7310013_lantern
lanterns838303_lanterns
lappers113717463_lappers
lapsers93911053_lapsers
larder73720973_larder_
larkers113014513_larkers
lasers64925703_la_sers
lashers104121833_lashers
lasters75627693_lasters
lathers104321883_lathers
lauder73815013_lauder_
launder8309143_launder_
laveers10329363_laveers
lavenders1334753_lavenders
lavers94526363_la_vers
lawyers13377153_lawyers
layers93921183_la_yers
leaders83819603_leaders
leaners73718173lean_ers
lender73921273_lender_
lindens839413_lindens
liners65428853_lin_ers
lingers84223303_lingers
linkers114317713_linkers
linters73822633_linters
loaders83413433_loaders
loaners73913623loan_ers
loners64225813_lon_ers
longers84819543_longers
lowlanders1442693lowlanders
lungers83817093_lungers
lunkers113414603_lunkers
madders113513213_madders
mangers103521263_mangers
manners93417833_manners
maunders11348343maunders
meander1049973meander_
meaners94415243mean_ers
menders103818803_menders
minders103720123_minders
moaners92813553moan_ers
oleander936403oleander_
outlanders1144273outlanders
padders113312873_padders
pander93725523_pander_
paniers94717333_paniers
panners93621273_panners
panzers184012013_panzers
philanders1644273philanders
pinders103720473_pinders
placers114515263pla_cers
plaguers11286503plaguers
plaiters103512633plaiters
planer84122653plan_er_
planes85028083plan_e_s
planets93914083plan_ets
plankters1544583plankters
planless1036813planless
planner93511623planner_
planter94017803planter_
plashers133813453plashers
plasters103518133plasters
platers93924093pla_ters
platters103415283platters
players124313763pla_yers
pleaders113210183pleaders
plinkers14309393plinkers
plodders1235523plodders
plunder103810493plunder_
plungers11379393plungers
plunkers14328323plunkers
pomanders1436223pomanders
ponders103618843_ponders
pounders113113273pounders
prancers123210333prancers
raiders84615143_raiders
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
readers83823773rea_ders
relaunders1153103relaunders
renders83821673_renders
rounders92613693rounders
sander74828533_sander_
sangers84421943_sangers
scanners10379703scanners
senders83022353_senders
shaders115915553sha_ders
skankers11316483skankers
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slandered1137473slandered
slanderer1046673slanderer
slanderers1145143slanderers
slanderous1144893slanderous
slappers123710943slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
sledders10257373sledders
slender83413593slender_
sliders83515223sl_iders
slingers93712683slingers
solander948123solander_
sonders83820713_sonders
sounders93214113sounders
spaders104214473spa_ders
spankers14369863spankers
spanners103710773spanners
spenders113211743spenders
squanders1934443squanders
standees93310143standees
stander84316163stander_
stranders10389933stranders
sunders84120053_sunders
tandems1037633_tandems
tankers113416913_tankers
tanners74018393_tanners
tenders83719723_tenders
thankers15297833thankers
thunders1236953thunders
tinders84219173_tinders
traders84316953tra_ders
twangers12226063twangers
uitlanders1142833uitlanders
uplander1145533uplander_
vanners103612843_vanners
venders113717003_venders
wadders123812443_wadders
waders109120643_wa_ders
wander104423713_wander_
wankers144514713_wankers
wanters104420093_wanters
warders113416813_warders
weaners104613833wean_ers
winders113721263_winders
wonders113315993_wonders
yarders113211593_yarders
zander163417113_zander_

Search took 10 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.1701051123.5
2DLD Change Limit1461625088.70316794.4
3Display Results5085080.2032502.5
 (SQL Overall)1786915089.07619688.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.