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

411 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
punsters10331058(None) 
munsters104010541munsters
pensters103012121pensters
punster92911101punster_
punters93617031pun_ters
bunters94717112bun_ters
bursters1038982bursters
busters94724122bu_sters
dusters84918352du_sters
hunters103915722hun_ters
justers143815722ju_sters
lusters73921432lu_sters
minsters103813912minsters
monsters103314532monsters
muensters1143252muensters
munster93710522munster_
musters94522492mu_sters
ousters74122772ou_sters
pasters94531732p_asters
penster92811952penster_
pesters93827092p_esters
piasters102912802piasters
pinasters1136812pinasters
plasters103518132plasters
posters93927992p_osters
presters103419002presters
pulsers94213152puls_ers
punchers152610072punchers
punishers1434972punishers
punkers133714852pun_kers
punners94114232pun_ners
punter84320022pun_ter_
pursers93916092purs_ers
pursuers10376522pursuers
pushers123814502pu_shers
putters94219182pu_tters
questers17168762questers
spinsters1136602spinsters
ulsters72711982_ulsters
uniters73814172_uniters
unsteps936212_unsteps
answers1037043_answers
asters65631603__asters
austere7312993au_stere
banisters11189473banisters
banters94623113ban_ters
basters94930303_basters
bisters93922603_bisters
blasters104116143blasters
blisters104015083blisters
blusters104413883blusters
boasters103915653boasters
bolsters103712443bolsters
boosters104013433boosters
bundlers11399183bundlers
bunglers11398483bunglers
bunkers133715953bun_kers
bunter85020383bun_ter_
burster9310293burster_
bushers124018803bu_shers
buskers133414083bu_skers
buster84726493bu_ster_
bustiers103810043bu_stiers
bustlers104210613bu_stlers
butters94521713bu_tters
canisters112310183canisters
canters94827723can_ters
casters94729893_casters
censers94313903cens_ers
centers94420593cen_ters
chunters133910893chun_ters
clusters102912393clusters
clysters13227823clysters
coasters104317303coasters
costers94128303_costers
counters103320183coun_ters
cunners93913463cun_ners
cursers94317153curs_ers
cussers94213393cu_ssers
cutters94218953cu_tters
dabsters1137053dabsters
daunters9329843daun_ters
diasters92913173diasters
diesters92513593diesters
dumpsters1453743dumpsters
dunites8313593dunite_s
dunkers123512193dun_kers
duster74919723du_ster_
easters75125683_easters
enters64425643_en_ters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibsters13126403fibsters
flusters113811493flusters
fosters104220093_fosters
functors1335743functors
funders113813933fun_ders
funkers143712063fun_kers
fussers104210813fu_ssers
gagsters10317073gagsters
gangsters11205733gangsters
ganisters10248313ganisters
gasters85624283_gasters
glisters93912603glisters
gristers94013403gristers
grunters9359023grun_ters
guessers9174893guessers
gunites8313123gunite_s
gunners83111723gun_ners
gunsels8338133guns_els
gushers113512503gu_shers
gutters83715503gu_tters
gypsters1434023gypsters
hamsters13710423hamsters
haunters11329533haun_ters
heisters113413133heisters
hinters103719573hin_ters
hipsters13268783hipsters
hoisters113513473hoisters
holsters113211933holsters
hucksters1843653hucksters
hungers114013303hun_gers
hunkers143314333hun_kers
hunter94817773hun_ter_
hurters103413633hu_rters
huskers143510033hu_skers
hustlers11349203hu_stlers
igniters9126223igniters
instars7411113_instars
insteps936573_insteps
inters64328043_in_ters
jesters144118193_jesters
jousters153210403jousters
junipers1733923junipers
junkers184010863jun_kers
junketers2042933junketers
juster134617013ju_ster_
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310143kiesters
klisters123910483klisters
lamsters1099753lamsters
lasters75627693_lasters
leisters83312823leisters
linters73822613lin_ters
listers74026523_listers
lobsters10268733lobsters
lunchers13349563lunchers
lungers83817083lun_gers
lunkers113414603lun_kers
luster64023673lu_ster_
lustres73013233lu_stres
masters94628923_masters
meisters103313843meisters
ministers1139613ministers
minster93914323minster_
minters93822463min_ters
misters93927503_misters
mobsters12359053mobsters
monster93214593monster_
monstera10318873monstera
monsteras11318213monsteras
mounters103712493moun_ters
muenster1043313muenster_
munchers15318773munchers
musers84719093mu_s_ers
mushers124016433mu_shers
mustees94614923mu_stees
muster84724523mu_ster_
mutters94117133mu_tters
nesters74422783_nesters
niters64624203__niters
noters64020993__noters
nursers74311833nurs_ers
nutters74215423nu_tters
oldsters996733oldsters
ouster64223733ou_ster_
outers64230163ou__ters
outsteers936033outsteers
oysters103411683_oysters
painters103013023painters
palters94021683p_alters
panders103423733pan_ders
paniers94717333pan_iers
panners93621273pan_ners
panniers10488853panniers
pansies94521983pansie_s
panthers13510783panthers
panzers184012013pan_zers
parsers94118153pars_ers
passers94717753p_assers
pastels95215183p_astels
paster85734373p_aster_
pastern94415063p_astern
pasterns104112623p_asterns
pastes85233913p_aste_s
pastors94118993p_astors
paters84935823p__aters
patters94825193p_atters
pausers94113223paus_ers
pelters93720313p_elters
penates93321593penate_s
penners93414183pen_ners
pensees9311203pens_ees
pester84827593p_ester_
peters86624593p__eters
petters93722363p_etters
pewters124113353p_ewters
philters1398173philters
piaster93012883piaster_
piastres10249303piastres
pilasters1138213pilasters
pilsners1035533pilsners
pinaster1037113pinaster_
pincers113916503pin_cers
pinchers153510613pinchers
pinders103720473pin_ders
pingers104020733pin_gers
pinites9319533pinite_s
pinkers134118603pin_kers
pinners93518593pin_ners
pinschers1644373pinschers
pinsetters1244103pinsetters
pishers123815753p_ishers
pissers95014753p_issers
pistes85325633p_iste_s
plaisters1137813plaisters
plaiters103512633plaiters
plankters1544583plankters
planters102915323planters
plashers133813453plashers
plaster93318693plaster_
plastery13279703plastery
platers93924083p_laters
platters103415283platters
pleaters103613783pleaters
plotters104011553plotters
plunders11329823plun_ders
plungers11379393plun_gers
plunkers14328323plun_kers
pointers103013723pointers
poisers94214433pois_ers
pollsters1137173pollsters
ponders103618843pon_ders
pontes83627853pon_te_s
poofters1336923poofters
porters93722703p_orters
posers84223973p_os_ers
poster84129173p_oster_
postern93615603p_ostern
posterns102713703p_osterns
potters94024343p_otters
poulters103911043poulters
pouncers12349203poun_cers
pounders113113263poun_ders
pouters94221863p_outers
powters124015653p_owters
pranksters1653283pranksters
praters94921643p_raters
pressers103215023pressers
prester93519623prester_
printers103214903printers
prosers94219643pros_ers
prospers123012253prospers
pruners93710723prun__ers
psalters10227713psalters
puckers153514673pu_ckers
puddlers12298683puddlers
puffers15349203pu_ffers
puisnes937423puisne_s
pulers83820283pu__lers
pullers93618483pu_llers
pulpers114612283pu_lpers
pulsars9358913puls_ars
pulsates1048813pulsate_s
pulsators1175373pulsators
pulser84215193puls_er_
pulses83818663puls_e_s
pumicers1434353pumicers
pumpers133113673pu_mpers
puncher143311673puncher_
punches144816133punche_s
puncture1245053puncture
punctures1345343punctures
pungles104013713pungle_s
punier84519223pun_ier_
puniness101610273puniness
punisher1335773punisher_
punishes1338113punishe_s
punitory1345603punitory
punker123718823pun_ker_
punkeys16366493pun_keys
punkier133512793punkier_
punkies134216803punkie_s
punner84918153pun_ner_
punnets9409263pun_nets
punnier93511263punnier_
punted94618713pun_te_d
punties94520783pun_ties
puntos85915793pun_t_os
punts75828003pun_t__s
pupates113311433pupate_s
purflers13216963purflers
purgers104714003pu_rgers
purser85020473purs_er_
purses84826373purs_e_s
pursier94012753pursier_
pursuer9338893pursuer_
pursues94111373pursue_s
puses75532203pu_s_e_s
pusher114318283pu_sher_
pushes114621663pu_she_s
pusleys12286233pu_sleys
pusses84322843pu_sse_s
pussier93711993pussier_
pussies93615693pussie_s
pussleys13273173pussleys
puttees93612913pu_ttees
putter83921443pu_tter_
puttiers10288013puttiers
puzzlers18295143puzzlers
quarters173110443quarters
quashers20186803quashers
quester161410023quester_
questors17147003questors
quieters17248733quieters
quilters17228433quilters
quipsters2043593quipsters
quitters17238523quitters
quoters16369253qu_oters
ranters73323643ran_ters
rasters74629023_rasters
renters74224813ren_ters
resters74130403_resters
reuniters936423reuniters
rinsers73815743rins_ers
roasters83615913roasters
roisters83615543roisters
roosters83514653roosters
rosters73727533_rosters
rousters84315653rousters
roysters113610523roysters
runners74212453run_ners
runovers1134473runovers
rushers103816103ru_shers
rustlers8339853ru_stlers
saunters82911743saun_ters
shunters113210733shun_ters
shysters14106433shysters
sinters74024073sin_ters
sisters73721573_sisters
songsters1046093songsters
spinster1036683spinster_
spurters103311693spu_rters
sputters104012863spu_tters
sudsers83310413suds_ers
suiters73618873su_iters
sumpters1238023sumpters
sunders84120053sun_ders
sunsets72911573suns_ets
tapsters10318803tapsters
tasters74225643_tasters
taunters8259263taun_ters
tenters73921103ten_ters
testers74124543_testers
tinters74221103tin_ters
tipsters10278503tipsters
toasters83912703toasters
trusters83112243trusters
trysters11298363trysters
tufters10298343tu_fters
tuners64417343tun__ers
tungstens1042223tungstens
tuskers113710033tu_skers
tussers74313563tu_ssers
twisters11268173twisters
ulster63712103_ulster_
undoers82910573_undoers
uniter64619143_uniter_
unites65024853_unite_s
unmiters1037073_unmiters
unsets64116163_uns_ets
unsews9379363_uns_ews
unsteel738793_unsteel
unsteels845793_unsteels
unstep839223_unste_p
unstops936983_unstops
unstress837373_unstress
unswears1144023_unswears
updaters11255173updaters
upsteps1133743_upsteps
upstirs935293_upstirs
ureters7311823_ureters
users55817573_u_s_ers
ushers94415533_u_shers
utters63817113_u_tters
vaunters11327743vaun_ters
venters103717723ven_ters
waisters113811523waisters
wanters104420093wan_ters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
winters103720473win_ters
wresters112711733wresters
xysters17307163_xysters
youngsters1441973youngsters
zesters163517293_zesters
zosters163015403_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.1701051123.5
2DLD Change Limit1461624117.81318707.5
3Display Results4114110.1562634.6
 (SQL Overall)1786914118.13921954.9
 
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.