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

448 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
gagster931763(None) 
gagsters10317081gagsters
gangster10215771gangster
gaster75027351ga_ster
aster55434892_a_ster
baster85333592ba_ster
caster85232572ca_ster
dabster1036702dabster
dragster1034622dragster
easter65027982ea_ster
fagoter1135882fagoter
faster94625772fa_ster
gager74726292gag__er
gagger95016512gag_ger
gaiter73819502ga_iter
gamester1137322gamester
gangsters11205732gangsters
ganister9178992ganister
garter74420512ga_rter
gasher104320372ga_sher
gasper94515542ga_sper
gasser75017772ga_sser
gassier83812572gassier
gasted84821582ga_sted
gasters85624292ga_sters
gater64533652ga__ter
gaunter82910712gaunter
glister84013342glister
grister83915412grister
gypster1333952gypster
hamster12810422hamster
lamster9109912lamster
laster64830632la_ster
magister1136282magister
master84831342ma_ster
paster85734372pa_ster
raster64731442ra_ster
tapster9299272tapster
taster64930572ta_ster
vaster94521022va_ster
waister103812382waister
waster95228942wa_ster
abater85518123_abater
acuter84412863_acuter
after85719793_a_fter
agate66525153_agate_
agates76121343_agates
ager55935843_ag__er
agger76420893_ag_ger
agisted938203agisted
alter54828503_a_lter
answer936893_answer
apter76120203_a_pter
asker96418783_a_sker
asper75520433_a_sper
astern64815813_a_stern
asters65631603_a_sters
astir55517093_a_stir
auguster943953auguster
austere7312993_austere
bagger104619203bag_ger
baggier113611643baggier
baiter84422553ba_iter
baluster1037053baluster
banister10199973banister
banter84825333ba_nter
barter85525373ba_rter
baser74828923ba_s_er
basher115123813ba_sher
baste74829983ba_ste_
basted95227233ba_sted
basters94930303ba_sters
bastes85330383ba_stes
batter84928873ba_tter
bister84922763_bister
blaster94017303blaster
blister94415313blister
bluster94215313bluster
boaster94616433boaster
bolster93713423bolster
booster94314553booster
burster9310293burster
buster84726493_buster
cadaster1136903cadaster
cager85229223cag__er
cagier93715933cag_ier
canister101710853canister
canter85230113ca_nter
carter84932273ca_rter
caste75932363ca_ste_
casters94729903ca_sters
castes85631863ca_stes
castor84418533ca_stor
cater74840723ca__ter
causer84117783caus_er
chaster124718503chaster
cluster94013333cluster
clyster12317453clyster
coaster94219043coaster
coster84331293_coster
dabsters1137053dabsters
dafter104813343da_fter
dagger95017303dag_ger
darter75320363da_rter
dasher104318983da_sher
dater65332313da__ter
daughter1344503daughter
daunter83811753daunter
daystar1143443daystar
diaster82813313diaster
diester83013683diester
digester10258433digester
dragsters1134323dragsters
duster74919723_duster
eager65526973eag__er
eagerer8248823eagerer
easier64218463ea_sier
eastern74412533ea_stern
easters75125683ea_sters
eater54639843ea__ter
ester54727713__ester
faggier12309843faggier
fagoted1236073fagoted
fagoters1234863fagoters
fainter103611053fainter
falser93912413fals_er
falter94519053fa_lter
fasted105320953fa_sted
fasten95114893fa_sten
fatter94523213fa_tter
feaster10812983feaster
fester94723513_fester
fibster12146533fibster
fighter143010773fighter
fluster103913063fluster
foster94322223_foster
gabber114916603ga_bber
gabbier12379633gabbier
gabbler124013303gabbler
gadder93714713ga_dder
gadgeteer1242413gadgeteer
gaffer134310133ga_ffer
gage65936103gag__e_
gaged85522313gag__ed
gagers84021333gag__ers
gages74529973gag__es
gagged104817153gag_ged
gaggers103413663gag_gers
gaggle93412623gaggle_
gaggled11359913gaggled
gaggles103512593gaggles
gagmen103910413gag_men
gags66441063gags___
gainer74117493ga_iner
gaited84416923ga_ited
gaiters83516543ga_iters
galatea839953galatea
gambier124711973gambier
gambler123612683gambler
gamer84928943ga__mer
gamesters1236733gamesters
gamete9313593gamete_
gametes10312253gametes
gamier93617933ga_mier
gammer1112318333ga_mmer
gammier123711193gammier
gander84322763ga_nder
gangbuster1451963gangbuster
ganger83721463ga_nger
ganglier1047603ganglier
gangsta944513gangst_a
gangstas1044403gangstas
ganisters10248313ganisters
gannister1054173gannister
gaoler73913573ga_oler
gaper86125123ga__per
gappier12369843gappier
garbler104012563garbler
gargler93710263gargler
garner73917003ga_rner
garote7717953garote_
garoted9710133garoted
garotes8614563garotes
garotter965943garotter
garroter956573garroter
garters84218233ga_rters
gases65633993ga_s_es
gashed116321973ga_shed
gashes105725153ga_shes
gasket114417253ga_sket
gasmen93111563ga_smen
gasped104814293ga_sped
gaspers105014133ga_spers
gassed85217633ga_ssed
gassers84714633ga_ssers
gasses75724783ga_sses
gast56052563ga_st__
gastrea847223ga_strea
gasts66628633ga_st_s
gate55746573ga__te_
gated75329773ga__ted
gaters74728643ga__ters
gates65939513ga__tes
gather104115853ga_ther
gator64416033ga__tor
gaucher1337233gaucher
gaudier938453gaudier
gauffer1474423gauffer
gauger84714853ga_uger
gausses8308693gausses
gauzier1735633gauzier
gawker14559353ga_wker
gawkier15326523gawkier
gawper12499693ga_wper
gawsie1038463gawsie_
gayer94519193ga__yer
gazer155720073ga__zer
geste65920693g_este_
gestes75721393g_estes
getter74117613g_etter
geyser1036513geys_er
ghosted1236273ghosted
ghostier1235383ghostier
giggler101029883giggler
glassier9289083glassier
glisten8418083glisten
glisters93912603glisters
glitter84211803glitter
gloater83711013gloater
glosser83410813glosser
goggler10379323goggler
goiter74116203g_oiter
goosier83512563goosier
gorsier83811073gorsier
grafter114211153grafter
granter84117133granter
grasper10389793grasper
grassier9349283grassier
grater74625443g_rater
greater84416493greater
greeter82812673greeter
grifter113810493grifter
gristers94013403gristers
gritter83913353gritter
grosser84313143grosser
grouter84412523grouter
grunter83110783grunter
guesser8166543guesser
guested9157713guested
gusher104115773g_usher
gusted84316723g_usted
gustier83813863g_ustier
gutsier8389823gutsier
gutter73817713g_utter
gypsters1434023gypsters
hafter124815883ha_fter
haggler12328933haggler
halter94420883ha_lter
hamsters13710423hamsters
harsher13310363harsher
haste85927863ha_ste_
hasted105125283ha_sted
hasten95718563ha_sten
hastes95727073ha_stes
hastier103916623ha_stier
hater85034753ha__ter
hatter94724873ha_tter
haunter103111153haunter
hawser125910843haws_er
heister103613623heister
hipster12288783hipster
hoister103714203hoister
holster103512213holster
jager134318133jag__er
jagger154016003jag_ger
jaggier16339183jaggier
jasper154610383ja_sper
jester134319153_jester
jouster143311043jouster
juster134617013_juster
kaiser103610373kais_er
kasher134915033ka_sher
keester11319913keester
keister113011573keister
keyster14256153keyster
kiester11329973kiester
klister113410643klister
lager65132863lag__er
lagger85919833lag_ger
lamister1037653lamister
lamsters1099753lamsters
lapser84113143laps_er
laser54633323la_s_er
lasher94824533la_sher
lassoer7379383lassoer
lasted74323603la_sted
lasters75627693la_sters
later54843923la__ter
latter65027893la_tter
laughter1245113laughter
leister73212753leister
lighter113113443lighter
lister64527253_lister
lobster9288853lobster
luster64023673_luster
magisters1235803magisters
maltster1035303maltster
maser75029973ma_s_er
masher114123203ma_sher
masker124416103ma_sker
masseter1037063masseter
massier93615223massier
masted94025803ma_sted
masters94628923ma_sters
mastery124214323ma_stery
mater74438863ma__ter
matter84325343ma_tter
meister93114163meister
minster93914323minster
mister84728563_mister
mobster11299213mobster
moister94015373moister
monster93214603monster
munster93710523munster
muster84724523_muster
nagger84016123nag_ger
naggier9309153naggier
nastier74115293na_stier
natter64420743na_tter
negater83711963negater
nester64124183_nester
oater55433733oa__ter
oldster896573oldster
ouster64223733_ouster
oyster94111703_oyster
pager84728203pag__er
painter93814563painter
palter84423263pa_lter
parser84822373pars_er
passer84721033pa_sser
paste74932953pa_ste_
pasted94426903pa_sted
pastel85918713pa_stel
pastern94415063pa_stern
pasters94531733pa_sters
pastes85233913pa_stes
pastier94320383pa_stier
pastor84817483pa_stor
pater74740723pa__ter
patter84628263pa_tter
pauser84415963paus_er
penster92811953penster
pester84827593_pester
piaster93012883piaster
plaister1068013plaister
plaster93318693plaster
poster84129173_poster
prester93519623prester
punster92911103punster
quester161410023quester
rafter94517583ra_fter
raiser66620103rais_er
ranter63826823ra_nter
raser55633413ra_s_er
rasher95024123ra_sher
rasper83917333ra_sper
rasters74629023ra_sters
rater54943283ra__ter
ratter64326313ra_tter
register939553register
rester63832433_rester
righter113212383righter
roadster935463roadster
roaster74116663roaster
roister73516203roister
rooster74415173rooster
roster64329083_roster
rouster73517083rouster
royster103110533royster
sager65432053sag__er
sagger84321073sag_ger
saggier92912063saggier
sagier73717163sag_ier
salter64325083sa_lter
saluter73512453saluter
sassier73413233sassier
saunter72913453saunter
scamster1235303scamster
seamster1037143seamster
shyster13116563shyster
sighter113412113sighter
sister64421583_sister
songster935793songster
tagger84017703tag_ger
tapsters10318803tapsters
tarsier74119253tarsier
tarter64023563ta_rter
taste55127233ta_ste_
tasted74123973ta_sted
tasters74225643ta_sters
tastes64126423ta_stes
tastier711817093ta_stier
tater54138613ta__ter
tatter64024573ta_tter
taunter73111453taunter
tauter64318023ta_uter
teamster1036293teamster
tester64227153_tester
tighter112910693tighter
tipster9299053tipster
toaster74414463toaster
truster73114313truster
tryster10369513tryster
twister10308953twister
ulster63712103_ulster
vaguer10448443vag_uer
vastier103613203va_stier
vaulter10257713vaulter
vaunter10309603vaunter
wafter124114613wa_fter
wager95925053wag__er
wagerer11328493wagerer
wagger113616013wag_ger
wagoner1136093wagoner
waisted114210943waisted
waisters113811523waisters
waiter94321253wa_iter
wanter94423053wa_nter
warsler10289893warsler
warstler11275933warstler
washer124720393wa_sher
waste86125053wa_ste_
wasted104423023wa_sted
wasters104026593wa_sters
wastery134610993wa_stery
wastes96224883wa_stes
water84733313wa__ter
watter93221983wa_tter
webster1236093webster
wester94222893_wester
wrester102812413wrester
xyster16366803_xyster
yachter1534913yachter
yager95616753yag__er
yatter94116213ya_tter
yester93417983_yester
zester153617793_zester
zoster153715853_zoster

Search took 8 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 Filter1786911340270.393454684.5
2DLD Change Limit1340274486.82619634.8
3Display Results4484480.1562871.8
 (SQL Overall)1786914487.37524229.3
 
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.