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

209 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
moistens1026877(None) 
moisten93110141moisten_
glistens9366592glistens
hoisters113513482hoisters
listens74014132_listens
meisters103313842meisters
mispens11311072m_ispens
mistend103812522m_istend
mistends11419592m_istends
misters93927512m_isters
mittens9349882m_ittens
mobsters12359062mobsters
modistes1138642modiste_s
moistened1246002moistened
moistener1145842moistener
moisteners1244782moisteners
moister94015372moiste_r
moistest1038762moistest
moistness1146342moistness
monsters103314552monsters
remoistens12164522remoistens
roisters83615552roisters
amosites10311233amosite_s
bisters93922613_bisters
blisters104015083blisters
boasters103915663boasters
boites84322703boi_te_s
bolsters103712453bolsters
boosters104013443boosters
bostons9312903bo_stons
chastens13429183chastens
christens14125413christens
cisterns10369573_cisterns
cloisters1137433cloisters
coasters104317333coasters
cointers103616413cointers
coistrels1145263coistrels
colistins1149223colistins
costers94128333co_sters
crispens12286253crispens
distend93312073_distend
distends10339823_distends
distent84120853_distent
existent1548263existent
existents1644983existents
fastens105511753_fastens
foisons1047613fois_ons
foisted113210603foiste_d
foisting122910503foisting
foists95413983foist__s
fosters104220103fo_sters
glisten8418083glisten_
glisters93912603glisters
goiters84014443goi_ters
gristers94013403gristers
hastens106214813_hastens
heisters113413133heisters
hoidens11329083hoi_dens
hoises94823673hois_e_s
hoisted113411293hoiste_d
hoister103714203hoiste_r
hoisting123610903hoisting
hoists95516023hoist__s
holsteins1245263holsteins
holsters113211943holsters
horstes104516113horste_s
hostels103712313ho_stels
hostess103210243ho_stess
jointers15289323jointers
joisted15379173joiste_d
joisting16328503joisting
joists134711033joist__s
jousters153210423jousters
keisters123212043keisters
kittens11347583_kittens
klisters123910483klisters
leisters83312823leisters
listees73416673_listees
listels74212433_listels
listen64816813_listen_
listers74026533_listers
lobsters10268743lobsters
loiters74116613loi_ters
loosens716310953loos_ens
magisters1235803magisters
maidens10349663mai_dens
maists85817573maist__s
martens93714953m_artens
masters94628923m_asters
meister93114163meiste_r
meristems1343553meristems
mestees94617753m_estees
middens11379383m_iddens
miens76118303m_i__ens
mildens10339933m_ildens
milters93619093m_ilters
ministers1139623ministers
minsters103813923minsters
minters93822473m_inters
mioses84318853mios_e_s
misers85025703m_is_ers
mises74740563m_is_e_s
mispen10312173m_ispen_
missels94614813m_issels
missend104411373m_issend
missends11368233m_issends
missense1037963m_issense
missent94318713m_issent
misses85130873m_isse_s
missets94516573m_issets
missteps12156143missteps
misted93625823m_iste_d
mister84728563m_iste_r
misterm114314513m_isterm
misterms123711353m_isterms
misteuk1335893m_isteuk
misting103623383m_isting
mistress10310703m_istress
mists76633903m_ist__s
mistune9310653m_istune
mistunes10311133m_istunes
miters84328783m_i_ters
mites75141803m_i_te_s
mitten83914093m_itten_
mizens174610253m_i_zens
mizzens17366123m_izzens
mobster11299213mobste_r
modiste1039283modiste__
moieties10311263moieties
moilers93615203moi_lers
moires8915633moi_re_s
moist76033583moist___
moistening1346233moistening
moistful1343853moistful
moistly1236613moist_ly
moisture1046653moisture
moistures1147323moistures
molesters1198873molesters
molten83311813mo_lten_
molters93816973mo_lters
momsers113810843moms_ers
monishes13311483monishe_s
monists93614783monist__s
monsoons1047343monsoons
monster93214603monste_r
monstera10318883monstera
monsteras11318243monsteras
montes84226933mo_nte_s
moorhens1344853moorhens
mooters93818623mo_oters
moreens939963mo_reens
morgens10310463mo_rgens
morsels94112653mors_els
moseys114711703mo_s_eys
moshers124017843mo_shers
moshes115222873mo_she_s
mossers94116193mo_ssers
mosses85527683mo_sse_s
moste75925083mo_ste__
mostest9314793mo_stest
mostests1036833mo_stests
mosts76028543mo_st__s
motels83616893mo__tels
motes75944003mo__te_s
motets84216193mo__tets
mottes85523693mo_tte_s
moulters103510783moulters
mounters103712503mounters
mousers95216443mous_ers
mouses85531423mous_e_s
mousses94012703mousse_s
moutons9410313mo_utons
munsters104010553munsters
mustees94614923m_ustees
musters94522513m_usters
noises65021853nois_e_s
omitters10277653omitters
ousters74122793_ousters
oysters103411693_oysters
pistes85325633_piste_s
pistons93016373_pistons
pointers103013723pointers
pointes93216753pointe_s
poisers94214433pois_ers
poises84226543pois_e_s
poisons9310353pois_ons
posteens10309733po_steens
posterns102713723po_sterns
posters93928013po_sters
postins93721203po_stins
premoistens15122903premoistens
quietens17246343quietens
remoisten11175883remoisten_
roasters83615933roasters
roister73516203roiste_r
roosters83514663roosters
rosters73727543ro_sters
rousters84315683rousters
roysters113610533roysters
sisters73721593_sisters
softens10347623so_ftens
toasters83912723toasters
twisters11268173twisters
waisters113811523waisters
whitens13428733whi_tens
worsens104610263wors_ens
worsteds1234483worsteds
zoisites1744973zoisite_s
zosters163015413zo_sters

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.423422437.4
2DLD Change Limit1461622096.92021121.7
3Display Results2092090.0962177.1
 (SQL Overall)1786912097.43924020.8
 
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.