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

153 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
moistest103876(None) 
mostest9314791mo_stest
mistiest103018312m_istiest
modestest1245002modestest
modistes1138642modistes_
moisten93110142moiste_n
moistens10268772moistens
moister94015372moiste_r
moistness1146342moistness
mossiest103112442mossiest
mostests1036832mo_stests
mousiest102711762mousiest
noisiest839762noisiest
amosites10311233amosites_
boites84322703boi_tes_
bossiest103112213bossiest
briskest14337803briskest
chastest1349703chastest
coattest1038863coattest
contest93523233co_ntest
cosiest93819853co_siest
crispest12177373crispest
distent84120853_distent
existent1548263existent
faintest1139073faintest
fastest102413723_fastest
feistiest1237073feistiest
fittest102510803_fittest
foisted113210603foiste_d
foists95413983foist_s_
goosiest92911823goosiest
gorsiest92511133gorsiest
hoises94823673hois_es_
hoisted113411293hoiste_d
hoister103714203hoiste_r
hoisters113513483hoisters
hoists95516023hoist_s_
honestest1247303honestest
horsiest112513263horsiest
horstes104516113horstes_
hostess103210243ho_stess
hottest10411383ho_ttest
joisted15379173joiste_d
joists134711033joist_s_
justest1449893_justest
loosest75811563loos_est
lousiest82311613lousiest
maists85817573maist_s_
massiest103314423massiest
meister93114163meiste_r
meisters103313843meisters
messiest103112423messiest
mesteso937133m_esteso
mildest102812063m_ildest
miltiest103015173m_iltiest
mintiest103217143m_intiest
minutest10247653minutest
mioses84318853mios_es_
miriest93619823m_iriest
mirkest13309723m_irkest
miscast11312423m_iscast
miseat82925713m_is_eat
mises74740563m_is_es_
miskept1538923m_iskept
mismeet113215163m_ismeet
mismet103722373m_isme_t
misseat93617243m_isseat
missent94318713m_issent
misses85130873m_isses_
misset85028153m_isse_t
missets94516573m_issets
misted93625823m_iste_d
mistend103812523m_istend
mister84728563m_iste_r
misterm114314513m_isterm
misters93927513m_isters
misteuk1335893m_isteuk
mistreat10313113m_istreat
mistress10310703m_istress
mistrust1049203m_istrust
mistryst1345843m_istryst
mists76633903m_ist_s_
mites75141803m_i_tes_
mitiest93520053m_itiest
mobster11299213mobste_r
mobsters12359063mobsters
modest93818453mo__dest
modiste1039283modiste__
moieties10311263moieties_
moires8915633moi_res_
moist76033583moi___st
moistened1246003moistened
moistener1145843moistener
moistful1343853moistful
moistly1236613moist_ly
moisture1046653moisture
moistures1147323moistures_
moldiest11249693moldiest
molest85022743mo__lest
monishes13311483monishes_
monists93614783monist_s_
monster93214603monste_r
monstera10318883monstera
monsters103314553monsters
montes84226933mo_ntes_
moodiest112712183moodiest
mooniest103014173mooniest
mooriest102812723mooriest
mopiest113014293mo_piest
moshes115222873mo_shes_
mosses85527683mo_sses_
moste75925083mo_ste__
mosts76028543mo_st_s_
motes75944003mo__tes_
motet75641193mo__te_t
motets84216193mo__tets
mothiest13311033mothiest
motliest10310773motliest
mottes85523693mo_ttes_
mouses85531423mous_es_
mousses94012703mousses_
mussiest103112933mussiest
mustiest103017533m_ustiest
mutest84218053m__utest
noises65021853nois_es_
nosiest73415673no_siest
obtest81213013_o_btest
oftest91212003_o_ftest
oiliest72817683_oiliest
pistes85325633_pistes_
pointes93216753pointes_
pointiest1139623pointiest
poises84226543pois_es_
politest10312943politest
poshest12312423po_shest
posttest10410233posttest
quietest1757173quietest
robustest1143973robustest
roiliest8312283roiliest
roister73516203roiste_r
roisters83615553roisters
rosiest73919213ro_siest
softest10310603so_ftest
sonsiest8313033sonsiest
swiftest1434353swiftest
toastiest937423toastiest
tritest7315273tri_test
twistiest1235433twistiest
vastest102911513_vastest
whitest133710113whi_test
wisest95016443_wis_est
wristiest1237753wristiest
zoisites1744973zoisites_

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621536.40622816.4
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.88925938.6
 
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.