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

512 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
keister11301157(None) 
heister103613621heister
keester11319911keester
keisters123212041keisters
keyster14256151keyster
kiester11329971kiester
klister113410641klister
leister73212751leister
meister93114161meister
bister84922762_bister
blister94415312blister
demister11310222demister
diester83013682diester
easter65027982_easter
ester54727712_e_ster
feaster10812982feaster
feistier1136192feistier
fester94723512fe_ster
glister84013342glister
grister83915412grister
heisted113210652heisted
heisters113413132heisters
hoister103714202hoister
jester134319152je_ster
kaiser103610372kais_er
keesters12319592keesters
kelter103214372ke_lter
keysters15326332keysters
kiesters123310142kiesters
kilter103714342k_ilter
kisser104212452k_isser
kiter95523212k_i_ter
klisters123910482klisters
knitter11348132knitter
leisters83312822leisters
lister64527252_lister
meisters103313842meisters
mister84728562_mister
moister94015372moister
nester64124182ne_ster
penster92811952penster
pester84827592pe_ster
register939552register
reinter73116842reinter
resister8311652resister
rester63832432re_ster
roister73516202roister
seiser65318342seis_er
sister64421582_sister
tester64227152te_ster
twister10308952twister
waister103812382waister
webster1236092webster
wester94222892we_ster
yester93417982ye_ster
zester153617792ze_ster
agisted938203agisted
assister836753assister
aster55434893__aster
baiter84422553bai_ter
banister10199973banister
baster85333593_baster
beater84729393be_ater
belter84720963be_lter
bemisted1368383bemisted
bested94922753be_sted
bestir8311163be_stir
better84723703be_tter
bisters93922603_bisters
bistre83815023_bistre
biter75030033_bi_ter
bitter84622673_bitter
blaster94017303blaster
blisters104015083blisters
blistery13418713blistery
bluster94215313bluster
boaster94616433boaster
bolster93713423bolster
booster94314553booster
brisker134210293brisker
burster9310293burster
buster84726493_buster
canister101710853canister
caster85232573_caster
ceiler84013963cei_ler
censer84516583cens_er
center84421413ce_nter
chaster124718503chaster
chitter124112963chitter
cisted95217523_cisted
cistern93310693_cistern
citer74827323_ci_ter
cloister1037093cloister
cluster94013323cluster
clyster12317453clyster
coaster94219033coaster
cointer93616723cointer
coster84331293_coster
crisper113511053crisper
critter94113033critter
dabster1036703dabster
debater104114693debater
deemster1175713deemster
defter104215923de_fter
deicer94114413dei_cer
deifier113013123deifier
deist64633593deist__
deistic10311173deistic
deists74916433deist_s
delisted10310563delisted
deluster936903deluster
demisters1249203demisters
dempster1355773dempster
denser74115193dens_er
depicter1356853depicter
desirer8310783desirer
desisted1039783desisted
deter65028043de__ter
detester9239683detester
deviser114212393devis_er
dewater112912423dewater
dexter143810893de_xter
diaster82813313diaster
diesters92513593diesters
dieter73516773_dieter
drifter11348703drifter
duster74919723_duster
easier64218463_easier
eastern74412533_eastern
easters75125683_easters
eater54639843_e_ater
eider64624743_ei_der
either94517423_either
ekistic1377843ekistic
elater64724203_elater
emitter93211083emitter
emoter85415193_emoter
enlister847803enlister
enter54726383_e_nter
epistler1044833epistler
esker94412983_e_sker
esters64627733_e_sters
existed1538473existed
fainter103611053fainter
faster94625773_faster
feasted11310843feasted
feasters11511563feasters
feater95224053fe_ater
feigner1135593feigner
feinted11379623feinted
feist86230073feist__
feists94915313feist_s
feisty12449293feist_y
festers104121393fe_sters
fetter94120383fe_tter
fibster12146533fibster
filister1137403filister
filter94517633_filter
fisher124917143_fisher
fisted104218703_fisted
fitter94120033_fitter
flirter10318673flirter
flitter103413903flitter
fluster103913063fluster
foisted113210603foisted
foster94322223_foster
frisker14389273frisker
fritter103912773fritter
gagster9317633gagster
gaiter73819503gai_ter
ganister9178993ganister
gaster75027353_gaster
geste65920693ge_ste_
gestes75721393ge_stes
getter74117613ge_tter
geyser1036513geys_er
glisten8418083glisten
glisters93912603glisters
glitter84211803glitter
goiter74116203goi_ter
grifter113810493grifter
gristers94013403gristers
gritter83913353gritter
gypster1333953gypster
hamster12810423hamster
heater94828303he_ater
hefter124313923he_fter
heifer1238203hei_fer
heist87030913heist__
heists96814633heist_s
hemipter1545583hemipter
hinter94021303_hinter
hipster12288783hipster
hisser94713793_hisser
histed104420243_histed
hitter94419863_hitter
hoisted113411293hoisted
hoisters113513473hoisters
holster103512213holster
insister888783insister
inter55028493__inter
jested144416503je_sted
jesters144118193je_sters
jilter133512513_jilter
jitter133314993_jitter
jointer14379713jointer
joisted15379173joisted
jokester1934443joke_ster
jouster143311043jouster
juster134617013_juster
kaisers11369273kais_ers
kasher134915033k_asher
keener104012833ke_ener
keeper123811913ke_eper
kegeler1245493kegeler
kegger12388063ke_gger
kegler11398233ke_gler
keir86217873kei___r
kelters113813753ke_lters
kente95821063ke_nte_
kentes105118643ke_ntes
kersey1336783kers_ey
kestrel1137113ke_strel
keynoter1542383keynoter
keyset13411523keys_et
keysets1434343keysets
kicker114116183k_icker
kidder123811093k_idder
kier86526803k_i__er
killer104917953k_iller
kilted113613833k_ilted
kilters113813593k_ilters
kinder113716843k_inder
kipper143414203k_ipper
kismet123414623k_ismet
kissed114412853k_issed
kissers114211293k_issers
kisses104217333k_isses
kist86540793k_ist__
kists95822113k_ist_s
kite85338233k_i_te_
kited105120093k_i_ted
kiters105218583k_i_ters
kites95432543k_i_tes
kitted115114833k_itted
kittel10368863k_ittel
kitten104611483k_itten
kittler11338163k_ittler
knifer13598563kni_fer
knishes1438263knishes
knitted12337423knitted
knitters12336623knitters
knotter11317643knotter
kosher134412973k_osher
krater104014313k_rater
krimmer15376873krimmer
krises105016083kris_es
lamister1037653lamister
lamster9109913lamster
laster64830633_laster
leaser65322673leas_er
lefter93613433le_fter
leistered1037043leistered
leisure736693leisure
lesser63514853le_sser
letter63722583le_tter
lifter93814813_lifter
linter64625333_linter
lisper84114433_lisper
listed74322833_listed
listee64223063_listee
listel64214733_listel
listen64816813_listen
listers74026523_listers
liter54736343_li_ter
litter64324853_litter
lobster9288853lobster
loiter64619173loi_ter
luster64023673_luster
magister1136283magister
master84831343_master
meeter83616503me_eter
melter83520113me_lter
meristem1245743meristem
messier93412923messier
mestee84523883me_stee
meter75130323me__ter
milter84921233_milter
minister10410363minister
minster93914323minster
minter84425103_minter
miser75430403_mis_er
misted93625823_misted
misterm114314513_misterm
misters93927503_misters
mistier93418713_mistier
miter75734793_mi_ter
mobster11299213mobster
moisten93110143moisten
monster93214593monster
muenster1043313muenster
munster93710523munster
muster84724523_muster
neater64424313ne_ater
negater83711953negater
neist54628443neist__
neither1037573neither
nested74720063ne_sted
nesters74422783ne_sters
nestler73510443ne_stler
nestor63713413ne_stor
netter63722023ne_tter
neuter63713793ne_uter
newsier10147223newsier
niter55028973_ni_ter
noisier759453noisier
oersted839553oersted
oldster896573oldster
oleaster837263oleaster
omitter9298503omitter
ouster64223733_ouster
oyster94111703_oyster
painter93814563painter
paster85734373_paster
pearter9412743pearter
peise75825773peis_e_
peised94817683peis_ed
peises84125043peis_es
pelter83321623pe_lter
pensters103012123pensters
peripter1278753peripter
persister1146833persister
perter84422283pe_rter
pesters93827093pe_sters
pestier94317403pe_stier
peter74427593pe__ter
petter83924773pe_tter
pewter114013673pe_wter
philter12108213philter
piaster93012883piaster
pisher114317753_pisher
pisser84416383_pisser
piste75824603_piste_
pistes85325633_pistes
plaister1068013plaister
plaster93318693plaster
pointer93814933pointer
poiser84217243pois_er
poster84129173_poster
prester93519623prester
printer93917303printer
punster92911103punster
quester161410023quester
quieter162810333quieter
quilter16279803quilter
quipster1933933quipster
quitter162910753quitter
raiser66620103rais_er
raster64731443_raster
realter73716313realter
rebater93517903rebater
reciter94117263reciter
reenter73217793reenter
reested82916233reested
refilter1137153refilter
refuter104312193refuter
registers1038883registers
reifier103414523reifier
reinters82614773reinters
reissuer854523reissuer
reiver95318293rei_ver
relater73723143relater
relisted9312623relisted
remaster10311473remaster
remitter102810323remitter
remoter94815973remoter
renter64527413re_nter
resider84615803resider
resisted9312693resisted
resisters9310453resisters
resistor847673resistor
resite64128453resite_
resited85122423resited
resites74027793resites
rested74430783re_sted
resters74130403re_sters
reutter71010093reutter
reviser104114663revis_er
rioter64817283_rioter
riser55431053_ris_er
risker105414493_risker
ritter63822413_ritter
roaster74116663roaster
roisters83615543roisters
rooster74415173rooster
roster64329083_roster
rouster73517083rouster
royster103110533royster
seamster1037143seamster
seater64534153se_ater
sedater83713623sedater
seiner64622483sei_ner
seise54727853seis_e_
seised74218123seis_ed
seisers73816393seis_ers
seises64026713seis_es
seisor63712333seis_or
seisure738193seisure
seizer154114573sei_zer
semester1038903semester
sestet6826203se_stet
setter64023723se_tter
shifter132911073shifter
shyster13116553shyster
sifter94516233_sifter
sinister838583sinister
sinter63625923_sinter
sisters73721573_sisters
sitter63323383_sitter
skeeter113410413ske_eter
skelter113610003ske_lter
skirter11338483skirter
skitter113810393skitter
slitter73615873slitter
smiter83616413smi_ter
snifter10349623snifter
spinster1036683spinster
spitter94015183spitter
stinter73614513stinter
suiter64121813sui_ter
swifter13318053swifter
swisher13369523swisher
tapster9299273tapster
taster64930573_taster
teamster1036293teamster
teaser65421523teas_er
teeter65420313te_eter
tempter11358213tempter
tenser64919433tens_er
tenter64623933te_nter
terser67317823ters_er
tested74421523te_sted
testee64323303te_stee
testers74124543te_sters
testes65125823te_stes
testier74015643te_stier
tetter64322453te_tter
thirster1135673thirster
tilter63417693_tilter
tinter63923643_tinter
tipster9299053tipster
titer55430613_ti_ter
titter63421163_titter
toaster74414463toaster
triste63818643triste_
triter65120593tri_ter
truster73114313truster
tryster10369513tryster
twisted11277433twisted
twisters11268173twisters
twistier1134813twistier
twitter10278093twitter
ulster63712103_ulster
uniter64619143uni_ter
vaster94521023_vaster
veiler93814353vei_ler
veiner94514753vei_ner
veinier10269583veinier
venter94218723ve_nter
verser94516963vers_er
verste94515633verste_
verstes104014273verstes
vesper1138083ve_sper
vested104217353ve_sted
vestee94319153ve_stee
vetter93417643ve_tter
visiter1038863_visiter
waisted114210943waisted
waisters113811523waisters
waiter94321253wai_ter
waster95228943_waster
websters1335803websters
weigher14136343weigher
weighter1535603weighter
weiner94214133wei_ner
weirder1144923weirder
welsher13377443welsher
welter93417383we_lter
western102911093we_stern
westers105221963we_sters
wetter93919443we_tter
whisker17367933whisker
whisper15298013whisper
whisted144010013whisted
whistler1496313whistler
whiter124316393whi_ter
whitter139110893whitter
winter94222803_winter
wiser85522803_wis_er
wisher123617063_wisher
wisted104120273_wisted
wrester102812413wrester
wristier1136863wristier
writer94416513wri_ter
xyster16366803_xyster
yeasted1138503yeasted
yeastier1135393yeastier
yestern10338633ye_stern
zested164214043ze_sted
zesters163517293ze_sters
zestier163010223ze_stier
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.1561145455.1
2DLD Change Limit1340275127.06318975.9
3Display Results5125120.1862752.7
 (SQL Overall)1786915127.40524131.1
 
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.