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

372 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
kiesters12331015(None) 
diesters92513601diesters
keesters12319591keesters
keisters123212041keisters
kiester11329971kiester_
bimesters1336342bimesters
bisters93922612bi_sters
diasters92913182diasters
diester83013682diester_
dieters83216432die_ters
digesters11257882digesters
esters64627732__esters
festers104121392_festers
fibsters13126412fibsters
heisters113413132heisters
hipsters13268792hipsters
jesters144118192_jesters
keester11319912keester_
keister113011572keister_
kelters113813752k_elters
keysters15326332keysters
kilters113813602ki_lters
kissers114211292ki_ssers
kiters105218592ki__ters
klisters123910482klisters
leisters83312822leisters
listers74026532li_sters
meisters103313842meisters
minsters103813922minsters
misters93927512mi_sters
nesters74422792_nesters
pesters93827092_pesters
piasters102912812piasters
presters103419002presters
questers17168772questers
resters74130402_resters
rimesters1137492rimesters
sisters73721592si_sters
testers74124542_testers
tipsters10278522tipsters
westers105221962_westers
wresters112711732wresters
zesters163517292_zesters
abetters1057173abetters
arresters948203arresters
asters65631603__asters
attesters935813attesters
averters11249513averters
basters94930313_basters
beaters94925043_beaters
belters93819413_belters
bestirs9311133_bestirs
betters94422093_betters
bilsteds1134273bilsteds
bimester1236163bimester_
bister84922763bi_ster_
bistres94017213bi_stres
biters83925243bi__ters
bitters94920363bi_tters
blasters104116143blasters
bleaters103412323bleaters
blessers10277633blessers
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013453boosters
bursters1038983bursters
busters94724133_busters
casters94729903_casters
centers94420603_centers
cheaters133613513cheaters
cistern93310703ci_stern
cisterns10369583ci_sterns
citers85022983ci__ters
clusters102912403clusters
clysters13227843clysters
coasters104317343coasters
costers94128343_costers
dabsters1137053dabsters
deemsters1285023deemsters
deters74724683_de_ters
detesters10298303detesters
diastems11226523diastems
diaster82813313diaster_
diesels8429143dies_els
dieses75218693dies_e_s
diestrus946533diestrus
dieter73516773die_ter_
diethers1257453diethers
digester10258433digester_
digestors11257273digestors
dilaters92513063dilaters
diluters9288113diluters
dimeters11411093dimeters
diopters1137693diopters
disasters1039153disasters
diverters13227873diverters
dopesters1237283dopesters
dressers9359863dressers
dusters84918363_dusters
easters75125683_easters
eaters65535953__eaters
enters64425643__enters
erecters102611613erecters
eskers105312223__eskers
ester54727713__ester_
feasters11511563feasters
fester94723513_fester_
fetters103517903_fetters
fibster12146533fibster_
fielders12156773fielders
fiestas1038433fiest_as
figeaters1345753figeaters
fighters15269403fighters
filisters1237003filisters
filters103816553fi_lters
fishers134714723fi_shers
fitters104517753fi_tters
fleshers14339443fleshers
flusters113811503flusters
foresters12312543foresters
fosters104220103_fosters
fretters113410303fretters
gagsters10317083gagsters
gamesters1236743gamesters
gasters85624303_gasters
gestes75721393_geste_s
getters84216103_getters
glisters93912603glisters
greeters92610123greeters
gristers94013413gristers
guessers9174903guessers
gypsters1434023gypsters
hamsters13710423hamsters
heaters104225223_heaters
hefters134312003_hefters
heister103613623heister_
hinters103719583hi_nters
hipster12288783hipster_
hissers104112313hi_ssers
hitters104717593hi_tters
hoisters113513493hoisters
holsters113211943holsters
infesters12237713infesters
instars7411133_instars
insteps936573_insteps
inters64328053_i_nters
issuers746123_issuers
jester134319153_jester_
jilters144211963ji_lters
jitters144314473ji_tters
jokesters2044443jokesters
jousters153210423jousters
justers143815733_justers
kaisers11369273kais_ers
kashers143914023k_ashers
keeners113610783k_eeners
keepers133410983k_eepers
keggers13357043k_eggers
keglers12277773k_eglers
kelter103214383k_elter_
kentes105118653k_ente_s
kestrel1137113k_estrel
kestrels1235813k_estrels
keyster14256153keyster_
kibitzers2441863kibitzers
kickers124013293ki_ckers
kidders13399173ki_dders
kiers95320103ki___ers
killers114215583ki_llers
kilter103714343ki_lter_
kindlers13318483kindlers
kineses113111253kines_e_s
kippers153211433ki_ppers
kismets13306883ki_smets
kisser104212453ki_sser_
kisses104217333ki_sse_s
kists95822123ki_st__s
kiter95523223ki__ter_
kites95432553ki__te_s
kittens11347583ki_ttens
klezmers2341583klezmers
klister113410643klister_
kneaders1384713kneaders
kneelers12226213kneelers
knessets1243173knessets
knitters12336623knitters
knotters12276153knotters
koshers144811803k_oshers
kraters114212343k_raters
kreutzers2241263kreutzers
kreuzers2132063kreuzers
lamsters1099753lamsters
lasters75627693_lasters
leister73212753leister_
letters73819853_letters
lientery1134883lientery
lifters104313783li_fters
lighters123111393lighters
limiters10249333limiters
linters73822633li_nters
lispers94514323li_spers
listees73416673li_stees
listels74212433li_stels
listens74014133li_stens
lister64527253li_ster_
liters65429883li__ters
litters73422573li_tters
lobsters10268743lobsters
lusters73921443_lusters
masters94628923_masters
meeters94714543_meeters
meister93114163meister_
melters93918313_melters
mestees94617753_mestees
meters85625833_me_ters
milters93619093mi_lters
ministers1139623ministers
minster93914323minster_
minters93822473mi_nters
misenters1139543misenters
misers85025703mi_s_ers
missteers1135913missteers
missteps12156143missteps
mister84728563mi_ster_
misterm114314513mi_sterm
misterms123711353mi_sterms
miters84328783mi__ters
mobsters12359063mobsters
molesters1198873molesters
monsters103314553monsters
muensters1143253muensters
munsters104010553munsters
musters94522513_musters
nester64124183_nester_
nestlers8359233_nestlers
nestors73614973_nestors
netters73618583_netters
neuters74212273_neuters
niters64624213ni__ters
oldsters996733oldsters
oleasters936733oleasters
orienters937633orienters
ousters74122793_ousters
oysters103411693_oysters
pasters94531733_pasters
pelters93720313_pelters
pensters103012123pensters
pester84827593_pester_
peters86624593_pe_ters
petters93722363_petters
pewters124113353_pewters
piaster93012883piaster_
piastres10249303piastres
piecers114112253pie_cers
piercers12316723piercers
pilasters1138223pilasters
pilsners1035533pilsners
pinasters1136823pinasters
pipestems1542833pipestems
pishers123815753pi_shers
pissers95014753pi_ssers
pistes85325633pi_ste_s
plasters103518133plasters
pleaters103613793pleaters
posters93928013_posters
pressers103215023pressers
prester93519623prester_
priestess1145293priestess
punsters103310583punsters
quester161410023quester_
questors17147013questors
quieters17248743quie_ters
quipsters2043593quipsters
rasters74629023_rasters
reenters82915313reenters
reinters82614773reinters
renters74224823_renters
rester63832433_rester_
rievers104311453rie_vers
righters122610713righters
rimester1037813rimester_
rinsers73815743rins_ers
rioters73615523ri_oters
risers64624783ri_s_ers
riskers114011993ri_skers
ritters74020623ri_tters
riveters11228163riveters
roasters83615933roasters
roisters83615563roisters
roosters83514673roosters
rosters73727553_rosters
rousters84315683rousters
roysters113610533roysters
scepters1237803scepters
seaters74028943_seaters
seisers73816393seis_ers
semesters1139123semesters
sestets7911473_sestets
setters73822063_setters
sheeters113111863sheeters
shelters113412813shelters
shysters14106463shysters
sidesteps1243623sidesteps
siestas738813siest_as
sifters103714793si_fters
sighters122510603sighters
sinters74024083si_nters
sister64421583si_ster_
sitters74221553si_tters
skeeters12298963skeeters
skelters12349373skelters
skirters12337243ski_rters
skitters12349553ski_tters
smelters103310513smelters
specters122811063specters
spelters103912243spelters
spinsters1136613spinsters
sweaters113811063sweaters
swelters113110193swelters
tapsters10318803tapsters
tasters74225643_tasters
teeters74018303_teeters
tenters73921113_tenters
testees74215913_testees
tester64227153_tester_
testes65125823_teste_s
tetters74320473_tetters
theaters114211903theaters
thirsters1235233thirsters
tilters73315953ti_lters
tinters74221113ti_nters
tipster9299053tipster_
titers64526413ti__ters
titters74219623ti_tters
toasters83912723toasters
treaters83615853treaters
trimesters1245423trimesters
trusters83112263trusters
trysters11298373trysters
tweeters11287143tweeters
twisters11268173twisters
ulsters72711983_ulsters
ureters7311823ure_ters
venters103717733_venters
vespers1239033_vespers
vestees103513173_vestees
vetters104016323_vetters
viewers1337173vie_wers
visiters1137413visiters
waisters113811523waisters
wasters104026593_wasters
websters1335803websters
welters103516063_welters
wester94222893_wester_
western102911103_western
westerns11328963_westerns
wetters103817753_wetters
whetters14246653whetters
wielders12196613wielders
wieners103212483wie_ners
winters103720483wi_nters
wishers133215213wi_shers
wrester102812413wrester_
wrestlers12306103wrestlers
xysters17307163_xysters
yester93417983_yester_
yestern10338643_yestern
yielders12164743yielders
zester153617793_zester_
zosters163015413_zosters

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623727.29620033.2
3Display Results3723720.1562384.6
 (SQL Overall)1786913727.85822740.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.