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

428 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
keester1131991(None) 
keesters12319591keesters
keister113011571keister
keyster14256151keyster
kiester11329971kiester
deemster1175712deemster
detester9239682detester
diester83013682diester
easter65027982_easter
ester54727712__ester
feaster10812982feaster
fester94723512_fester
heister103613622heister
jester134319152_jester
keener104012842kee_ner
keeper123811922kee_per
keisters123212042keisters
kelter103214382k_elter
keysters15326332keysters
kiesters123310152kiesters
klister113410642klister
leister73212752leister
meeter83616502mee_ter
meister93114162meister
nester64124182_nester
penster92811952penster
pester84827592_pester
prester93519622prester
quester161410022quester
reenter73217792reenter
reested82916232reested
rester63832432_rester
semester1038902semester
skeeter113410412skee_ter
teeter65420312tee_ter
tester64227152_tester
webster1236092webster
wester94222892_wester
wrester102812412wrester
yester93417982_yester
zester153617792_zester
abetter958323abetter
adepter1036113adepter
alerter72111513alerter
arrester839253arrester
aster55434893__aster
attester836503attester
averter102410553averter
baster85333593_baster
beater84729393_beater
beefier12329093beefier
beeper103714093bee_per
beerier93613023beerier
beetler938033beetler
beezer174010523bee_zer
begetter11136313begetter
belter84720963_belter
besetter10137973besetter
bested94922753_bested
bestir8311163_bestir
better84723703_better
bimester1236163bimester
bister84922763_bister
blaster94017303blaster
bleater94515303bleater
blesser9329293blesser
blister94415313blister
bluster94215313bluster
boaster94616433boaster
bolster93713423bolster
booster94314553booster
burster9310293burster
buster84726493_buster
caster85232573_caster
celeste949653celeste_
celestes10310013celestes
cementer1239193cementer
censer84516583cens_er
center84421413_center
chaster124718503chaster
cheater124816963cheater
cheesier1335963cheesier
chested133811673chested
chestier1387423chestier
cluster94013333cluster
clyster12317453clyster
coaster94219043coaster
coster84331293_coster
crested103416533crested
dabster1036703dabster
debater104114693debater
decenter112412163decenter
deedier93011593deedier
deemsters1285023deemsters
deeper93613503dee_per
defeater122611663defeater
defter104215923_defter
deluster936903deluster
demister11310223demister
dempster1355773dempster
denser74115193dens_er
deserter91211603deserter
detecter11298733detecter
deter65028043_de_ter
detested10279623detested
detesters10298303detesters
devested13239133devested
dewater112912423dewater
dexter143810893_dexter
diaster82813313diaster
diesters92513603diesters
dieter73516773die_ter
digester10258433digester
dopester1137253dopester
dresser83611953dresser
duster74919723_duster
easier64218463_easier
eastern74412533_eastern
easters75125683_easters
eater54639843__eater
eelier64216463_eelier
eerier64320023_eerier
egested938123egested
elater64724203_elater
emoter85415193_emoter
enter54726383__enter
erecter93113393erecter
esker94412983__esker
esters64627733__esters
faster94625773_faster
feasted11310843feasted
feasters11511563feasters
feater95224053_feater
feebler1235823feebler
feeder103513843fee_der
feeler93215173fee_ler
feistier1136193feistier
festers104121393_festers
fetter94120383_fetter
fibster12146533fibster
fleeter103210363fleeter
flesher133610923flesher
fluster103913063fluster
forester11313673forester
foster94322223_foster
fresher132612643fresher
fretter103412753fretter
gagster9317633gagster
gamester1137323gamester
gaster75027353_gaster
geekier12286393geekier
geese64316003gees_e_
geest64829623geest__
geests75912163geest_s
geezer16278013gee_zer
geste65920693_geste_
gestes75721393_gestes
getter74117613_getter
geyser1036513geys_er
glister84013343glister
greater84416493greater
greeter82812673greeter
grister83915413grister
guesser8166543guesser
guested9157713guested
gypster1333953gypster
hamster12810423hamster
heater94828303_heater
heeder104216043hee_der
heeler93917313hee_ler
hefter124313923_hefter
heisted113210653heisted
heisters113413133heisters
hipster12288783hipster
hoister103714203hoister
holster103512213holster
honester1139713honester
infester11239433infester
jeerer13389933jee_rer
jested144416503_jested
jesters144118193_jesters
jokester1934443jokester
jouster143311043jouster
juster134617013_juster
kaiser103610373kais_er
kasher134915033k_asher
keeked104810123kee_ked
keeled114414273kee_led
keened114013633kee_ned
keeners113610783kee_ners
keepers133410983kee_pers
keet85347343kee_t__
keets95123483kee_t_s
keeve124512133kee_ve_
keeves133711993kee_ves
kegeler1245493kegeler
kegger12388083k_egger
kegler11398243k_egler
kelters113813753k_elters
kente95821073k_ente_
kentes105118653k_entes
kersey1336793kers_ey
kestrel1137113k_estrel
keynoter1542383keynoter
keyset13411533keys_et
keysets1434343keysets
kilter103714343k_ilter
kisser104212453k_isser
kiter95523213k__iter
klezmer2231933klezmer
klisters123910483klisters
kneader1275893kneader
kneeler11277573kneeler
kneesies1245543kneesies
knesset11310413knesset
knitter11348133knitter
knotter11317643knotter
kosher134412973k_osher
krater104014313k_rater
kreutzer2141273kreutzer
kreuzer2032353kreuzer
lamster9109913lamster
laster64830633_laster
leaser65322673leas_er
leerier73111503leerier
lefter93613433_lefter
leisters83312823leisters
lesser63514853_lesser
letter63722583_letter
lister64527253_lister
lobster9288853lobster
luster64023673_luster
master84831343_master
meeker12359983mee_ker
meeters94714543mee_ters
meisters103313843meisters
melter83520113_melter
messier93412923messier
mestee84523883_mestee
meter75130323_me_ter
minster93914323minster
mister84728563_mister
mobster11299213mobster
modester1197483modester
moister94015373moister
molester1099373molester
monster93214603monster
muenster1043313muenster
munster93710523munster
muster84724523_muster
neater64424313_neater
needer73614953nee_der
needier84010623needier
needler8388893needler
negater83711963negater
nested74720063_nested
nesters74422793_nesters
nestler73510443_nestler
nestor63713423_nestor
netter63722023_netter
neuter63713793_neuter
newsier10147223newsier
oersted839553oersted
oldster896573oldster
oleaster837263oleaster
ouster64223733_ouster
oyster94111703_oyster
paster85734373_paster
pearter9412743pearter
peeler83517383pee_ler
peeper103614803pee_per
pelter83321623_pelter
pensters103012123pensters
perter84422283_perter
pesters93827093_pesters
pestier94317403_pestier
peter74427593_pe_ter
petter83924773_petter
pewter114013673_pewter
piaster93012883piaster
plaster93318693plaster
pleater93916333pleater
poster84129173_poster
presser93717623presser
presters103419003presters
punster92911103punster
quested17168383quested
questers17168763questers
questor16146633questor
raster64731443_raster
realter73716313realter
rebater93517913rebater
recenter102715443recenter
reciter94117263reciter
reedier83815303reedier
reefer93314363ree_fer
reefier102912553reefier
reeker103715593ree_ker
reekier113111123reekier
reeler63822573ree_ler
reenters82915303reenters
reest54938093reest__
reests64618893reest_s
refuter104312193refuter
register939553register
reheater113413033reheater
reinter73116843reinter
rejecter17258943rejecter
relater73723143relater
reletter81311023reletter
remaster10311473remaster
remoter94815973remoter
renested92212953renested
renter64527413_renter
repeater102615443repeater
repenter102813863repenter
requester1855513requester
resetter81511833resetter
resister8311653resister
rested74430783_rested
resters74130403_resters
retested92212533retested
reutter71010093reutter
reverter114812873reverter
revested122612243revested
rimester1037813rimester
roaster74116663roaster
roister73516203roister
rooster74415173rooster
roster64329083_roster
rouster73517083rouster
royster103110533royster
scepter1138363scepter
seamster1037143seamster
seater64534163_seater
sedater83713633sedater
seeder74320773see_der
seedier83513633seedier
seeker103615363see_ker
seemer84418043see_mer
seepier92912013seepier
seiser65318343seis_er
semesters1139123semesters
sequester1844443sequester
sestet6826203_sestet
setter64023723_setter
sheeter103814913sheeter
shelter103214963shelter
shyster13116563shyster
sister64421583_sister
skeeters12298963skee_ters
skelter113610003skelter
smelter93311913smelter
specter113111733specter
speedster1252733speedster
spelter94113703spelter
svelter10359673svelter
sweater103712723sweater
sweeter103212003sweeter
swelter103711173swelter
tapster9299273tapster
taster64930573_taster
teamster1036293teamster
teaser65421523teas_er
teemer85515743tee_mer
teener64717503tee_ner
teenier72611143teenier
teensier835573teensier
teeters74018303tee_ters
teether10349693teether
tempter11358213tempter
tenser64919433tens_er
tenter64623933_tenter
terser67317823ters_er
tested74421523_tested
testee64323303_testee
testers74124543_testers
testes65125823_testes
testier74015643_testier
tetter64322453_tetter
theater104014253theater
tipster9299053tipster
toaster74414463toaster
treater74219833treater
truster73114313truster
tryster10369513tryster
tweeter10288533tweeter
twister10308953twister
ulster63712103_ulster
ureter6313203ure_ter
vaster94521023_vaster
venter94218723_venter
verser94516963vers_er
verste94515633verste_
verstes104014283verstes
vesper1138083_vesper
vested104217353_vested
vestee94319153_vestee
vetter93417643_vetter
waister103812383waister
waster95228943_waster
websters1335803websters
weeder103315513wee_der
weedier113810623weedier
weenier103210803weenier
weensier1134243weensier
weeper114313303wee_per
weepier12319273weepier
weest85026773weest__
weeted103913793wee_ted
weever123811443wee_ver
welsher13377443welsher
welter93417383_welter
western102911093_western
westers105221963_westers
wetter93919443_wetter
whetter13348803whetter
wrested113410933wrested
wresters112711733wresters
wrestler11306993wrestler
xyster16366803_xyster
yeasted1138503yeasted
yeastier1135393yeastier
yestern10338633_yestern
zested164214043_zested
zesters163517293_zesters
zestier163010223_zestier
zoster153715853_zoster

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274285.65623696.4
3Display Results4284280.1562743.6
 (SQL Overall)1786914286.21828737.7
 
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.