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 “moistures” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
moistures114732(None) 
moisture1046651moisture_
jointures16124872jointures
mistunes10311132m_istunes
mixtures1735752m_ixtures
moisturise1253252moisturise
moisturises1353232moisturises
moisturizes2252762moisturizes
postures10313782po_stures
bistres94017213_bist_res
ceintures1136733ceintures
cistuses1038283_cistuses
coiffures1743213coiffures
coinsures1136723coinsures
coistrel1046743coist_rel
coistrels1145263coist_rels
coituses1039623coi_tuses
construes11410133construes
costumes1258013co_stumes
coutures10311993co_utures
disturbs1145403_disturbs
fissures1136573_fissures
fixtures1835283_fixtures
gestures9310013_gestures
goitres8389563goi_t_res
hoisters113513483hoister_s
immixtures2151883immixtures
impostures1443803impostures
jointure15134833jointure_
jointured17133483jointured
leisures836683leis_ures
matures9314313m__atures
measures1038913meas_ures
meisters103313843meister_s
miniatures1245143miniatures
miscues11312393m_iscu_es
misfires132210583m_isfires
misrules1039383m_isrules
missuses10309683m_issuses
mistakes141213413m_istakes
misterms123711353m_isterms
misters93927513m_ister_s
misthrew16124763m_isthrew
mistimes12612613m_istimes
mistress10310703m_ist_ress
mistune9310653m_istune_
mistuned1157723m_istuned
mistypes15116713m_istypes
misuses93216023m_is_uses
mitres83922073m_i_t_res
mixture1635413m_ixture_
mobsters12359063mobster_s
modistes1138643modist__es
moidores1156343moi_dores
moieties10311263moiet_ies
moires8915633moi___res
moisten93110143moist__en
moistened1246003moistened
moistener1145843moistener
moisteners1244783moisteners
moistens10268773moist_ens
moister94015373moist__er
moistest1038763moist__est
moistness1146343moistness
moisturised1452293moisturised
moisturize2152883moisturize
moisturized2352503moisturized
moisturizer2252073moisturizer
moisturizers2351433moisturizers
monsteras11318243monsteras
monsters103314553monster_s
mosques18256913mo_squ_es
multures1039333m_ultures
obscures1245513_obscures
ossatures943423_ossatures
pastures10311963_pastures
pictures1249343_pictures
posture9313253po_sture_
postured1139493po_stured
posturer1038923po_sturer
posturers1137053po_sturers
roistered1037643roistered
roisterer946433roisterer
roisterers1045113roisterers
roisters83615553roister_s
scissures1143323scissures
seisures838273seis_ures
soilures836503soi_lures
tonsures869133tons_ures
tortures838913to_rtures
vestures11311043_vestures

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 Filter1786911486410.420425454.8
2DLD Change Limit148641916.90621523.5
3Display Results91910.0461978.3
 (SQL Overall)178691917.37224239.1
 
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.