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

434 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
gloaters928886(None) 
bloaters103311021bloaters
floaters112711511floaters
gloater83711011gloater_
bleaters103412322bleaters
bloater94013422bloater_
blotters104110982blotters
boaters93419242_boaters
clouters10399802clouters
coaters93525792_coaters
elaters74420192el_aters
floatels11295662floatels
floater104413352floater_
flouters11419272flouters
gaters74728642g__aters
glazers174410042gl_azers
gleamers11306562gleamers
gleaners9348072gleaners
glisters93912602glisters
glitters93710542glitters
gloated93511532gloate_d
gloats74515422gloat__s
glossers9319052glossers
glovers114310882glo_vers
glowers113412092glo_wers
goatees82710442g_oatees
goiters84014442g_oiters
graters85419742g_raters
groaners9248502groaners
grouters95910082grouters
loaders83413432_loaders
loafers10349462_loafers
loaners73913622_loaners
loathers113310442_loathers
locaters102710072_locaters
lofters103912902_lofters
loiters74116612_loiters
looters74419162_looters
lotters73921062_lotters
oaters65029792__oaters
platers93924092pl_aters
pleaters103613792pleaters
plotters104011552plotters
slaters73123732sl_aters
slotters84012402slotters
abaters95115203_abaters
aborters1038573aborters
adopters1136693adopters
alates64833973al_ate_s
allayers11156633allayers
allotters965563allotters
alters64924223al__ters
beaters94925043_beaters
bladers104214683bl_aders
blamers115314213bl_amers
blasters104116143blasters
blathers134713793bl_athers
blatters104414093blatters
blazers184811683bl_azers
bleater94515303bleater_
blisters104015083blisters
bloated104513433bloate_d
bloats85215763bloat__s
blockers16398793blockers
bloggers12397403bloggers
bloomers12348823bloomers
bloopers12397373bloopers
blotter94612853blotter_
blowers124313593blo_wers
blurters10348373blurters
blusters104413893blusters
boasters103915663_boasters
boatels93510233_boatels
boater84622093_boater_
bolsters103712453bolsters
bolters94017803_bolters
boosters104013443boosters
caters85336503__caters
cheaters133613513cheaters
clatters103313913clatters
clavers124314903cl_avers
clawers123910973cl_awers
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
clobbers14397513clobbers
clockers16369813clockers
cloggers12437283cloggers
cloisters1137433cloisters
cloners94514823clo_ners
closers94415323clo_sers
clouter93511693clouter_
clovers125114663clo_vers
clowders14357473clowders
clusters102912403clusters
clutters103210353clutters
clysters13227843clysters
coalers94419353_coalers
coasters104317333_coasters
coatees93816553_coatees
coater84329573_coater_
coaxers164311083_coaxers
colters93522443_colters
cooters94525723_cooters
copters113621283_copters
costers94128333_costers
cotters94323443_cotters
couters93827303_couters
craters95021893_craters
croakers14288523croakers
crofters13358903crofters
daters74827373__daters
debaters113511923debaters
dewaters122910723dewaters
dilaters92513063dilaters
diopters1137693diopters
doters74423913_do_ters
dotters83715973_dotters
eaters65535953__eaters
eglatere945163egl_atere
eglateres1044453egl_ateres
elater64724203el_ater_
elates65032363el_ate_s
eloiners8128153eloiners
elopers95112943elo_pers
eluates72014683eluate_s
emoters94712873emo_ters
flakers143613273fl_akers
flamers124616363fl_amers
flatters113814203flatters
flayers133912033fl_ayers
flirters11337933flirters
flitters114312173flitters
floated113312703floate_d
floatel10308013floate_l
floatier1136983floatier_
floats96816253float__s
floggers13387863floggers
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
flossers11307863flossers
flouter104311343flouter_
flowers133413173flo_wers
flusters113811503flusters
fluters103713683fl_uters
flutters114010823flutters
foamers123812103_foamers
folates103218453folate_s
footers104618333_footers
fosters104220103_fosters
fraters103517213_fraters
gagers84021333g__agers
gagsters10317083gagsters
gaiters83516543g_aiters
galateas937153galateas
gallates92815533gallate_s
gamers94420833g__amers
gaolers83511563gao_lers
gapers94520473g__apers
garotters1055033garotters
garters84218233g_arters
gasters85624293g_asters
gater64533653g__ater_
gates65939513g__ate_s
gathers114315073g__athers
gators74115843g__ators
gazers164516303g__azers
gelates83219593gelate_s
geometers1238193geometers
getters84216103g_etters
glaces94218033gl_ace_s
glaciers11277903glaciers
glades84820343gl_ade_s
glaires84010143gl_aires
glairs75211333gl_a_irs
glamors1068123gl_amors
glancers11408003glancers
glanders103811503glanders
glares75518873gl_are_s
glazer164212263gl_azer_
glazes165315643gl_aze_s
glaziers18406563glaziers
gleamer10328513gleamer_
gleaner8379773gleaner_
gliders94811843gl_iders
glimmers13396153glimmers
glistens9366593glistens
glister84013343glister_
glitter84211803glitter_
glittery12375613glittery
gloams95210663gloa__ms
gloat65427683gloat___
gloating102611463gloating
globate1057823globate__
globated1265753globate_d
globes94314543glo_be_s
glomera1035943glo_mera
glories81915923glorie_s
glossators1152553glossators
glosser83410813glosser_
glosses84014123glosse_s
glosts74513813glost__s
glottis837173glo_ttis
glouted9429713gloute_d
glouts74414713glout__s
glover104513533glo_ver_
gloves104115183glo_ve_s
glower105114933glo_wer_
glozes164313353glo_ze_s
gluers75011153gl__uers
glutens8437593gl_utens
glutes74517673gl_ute_s
gluteus8386253gl_uteus
gnawers11356393g_nawers
goatee73219533g_oate_e
goateed9307063g_oateed
goatherd1335263g_oatherd
goatherds1444203g_oatherds
goats65527303g_oat__s
goers65520253g_o__ers
gofers104711513g_o_fers
goffers14409213g_offers
goiter74116203g_oiter_
goitres8389563g_oitres
golfers114410083g_olfers
gomers94116883g_o_mers
goners74420173g_o_ners
goobers10219623g_oobers
gophers1338983g_ophers
gorgers94813643g_orgers
gougers94911763g_ougers
graders94716013g_raders
grafters12409193grafters
granters93614143granters
grater74625443g_rater_
grates75429893g_rate_s
gravers114515273g_ravers
grazers175112453g_razers
greasers93410253greasers
greatens9307593greatens
greater84416493greater_
greeters92610113greeters
grifters12389233grifters
gristers94013403gristers
gritters94210633gritters
groaner82510133groaner_
groats74816653groat__s
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
gropers104813853gro_pers
grossers94410973grossers
groupers11358643groupers
grousers93810733grousers
grouter84412523grouter_
growers113612723gro_wers
growlers12327093growlers
grunters9359033grunters
gutters83715513g_utters
gypsters1434023gypsters
gyrates113610263gyrate_s
gyrators1246003gyrators
haters94930403__haters
heaters104225223_heaters
hoaxers17327133_hoaxers
holsters113211943holsters
hooters104520483_hooters
idolaters1045713idolaters
jolters143711993_jolters
jotters143413803_jotters
klisters123910483klisters
knotters12276153knotters
kraters114212343_kraters
laagers83411253_laagers
lacers85225253_l_acers
laders74927763_l_aders
lagers74826143_l_agers
lakers105225153_l_akers
lasers64925703_l_asers
lasters75627693_lasters
latens64620213_l_atens
later54843923_l_ater_
lathers104321883_l_athers
lavers94526363_l_avers
layers93921183_l_ayers
leaders83819603_leaders
leakers113415423_leakers
leaners73718173_leaners
leapers93716663_leapers
leasers74717843_leasers
leathers114215083_leathers
leavers103717783_leavers
letters73819853_letters
lifters104313783_lifters
linters73822633_linters
listers74026533_listers
liters65429883_l_iters
litters73422573_litters
loader74316313_loader_
loafer93610943_loafer_
loaner64416503_loaner_
loather103711003_loather_
loathes103513243_loathes
loaves94813853_loave_s
lobbers113713943_lobbers
lobsters10268743_lobsters
locater93113603_locater_
locates93218813_locate_s
locators102910433_locators
lockers133516923_lockers
lodgers95113833_lodgers
lofter94614723_lofter_
loggers94616133_loggers
loiter64619173_loiter_
lollers72713793_lollers
loners64225813_lo_ners
longers84819543_longers
lookers114014073_lookers
loopers93914033_loopers
looter64222323_looter_
lopers84424143_lo_pers
loppers113014103_loppers
losers65123583_lo_sers
lotter64025603_lotter_
lottery10389833_lottery
lottes65322753_lotte_s
louvers10359103_louvers
lovers94223433_lo_vers
lowers94624923_lo_wers
lusters73921443_lusters
maters85032393__maters
moaners92813553_moaners
molters93816973_molters
mooters93818623_mooters
negaters9349783negaters
noters64021003_no_ters
oater55433733__oater_
oldsters996733oldsters
oleasters936733oleasters
oleates7417833oleate_s
otters64021513__otters
outers64230173__outers
oxters134813273__oxters
paters84935833__paters
placaters1336473placaters
placers114515263pl_acers
plaiters103512633plaiters
planers94517943pl_aners
planters102915323planters
plasters103518133plasters
platens94213983pl_atens
plater84427693pl_ater_
plates85432243pl_ate_s
platters103415283platters
players124313763pl_ayers
pleaders113210183pleaders
pleasers104010293pleasers
pleater93916333pleater_
pleathers1446453pleathers
plodders1235523plodders
plotter94113663plotter_
plovers123611833plo_vers
plowers123812243plo_wers
poofters1336923poofters
porters93722703_porters
posters93928013_posters
potters94024343_potters
pouters94221873_pouters
powters124015663_powters
praters94921653_praters
quoters16369263quo_ters
raters63936583__raters
rebaters103413943rebaters
relaters83218153relaters
reloaders1036423reloaders
rioters73615513rio_ters
roamers93713463_roamers
roarers73812743_roarers
roasters83615933_roasters
roosters83514663roosters
rooters74522933_rooters
rosters73727543_rosters
rotters74421393_rotters
routers74822873_routers
scooters103511033scooters
scoters93313813sco_ters
scouters103411323scouters
seaters74028943_seaters
shooters112811583shooters
shouters113510623shouters
skaters113512963_skaters
slakers114115753sl_akers
slater64429183sl_ater_
slates64934063sl_ate_s
slathers113914783sl_athers
slavers103716503sl_avers
slayers104513323sl_ayers
slitters84014133slitters
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093slo_pers
slotter73314453slotter_
snorters83410583snorters
soakers114114953_soakers
soapers93715923_soapers
soarers74118093_soarers
solacers10268893solacers
solates73523853solate_s
sorters74221133_sorters
souters74422603_souters
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
staters73922343_staters
sweaters113811063sweaters
swotters11448483swotters
taters64932203__taters
theaters114211903theaters
toasters83912723_toasters
tooters73818773_tooters
toters65026363_to_ters
totters74618733_totters
touters74018353_touters
treaters83615843treaters
trotters83310243trotters
ulsters72711983ul_sters
unloaders1044403unloaders
updaters11255183updaters
violaters1245963violaters
voters95017443_vo_ters
waters95030633__waters
zoolaters1844983zoolaters
zosters163015413_zosters

Search took 9 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.423422437.4
2DLD Change Limit1461624348.08018089.4
3Display Results4344340.3731163.5
 (SQL Overall)1786914348.87620131.9
 
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.