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

73 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
moistened124600(None) 
moistener1145841moistener
glistened11174282glistened
listened9168812_listened
mistend103812522m_isten_d
mistended13137332m_istended
mistuned1157722m_istuned
mittened1136362m_ittened
moisten93110142moisten__
moisteners1244782moisteners
moistens10268772moisten_s
remoistened1453172remoistened
roistered1037642roistered
bistered112913323_bistered
blistered12167683blistered
bolstered1246093bolstered
chastened1545883chastened
christened1643613christened
cloistered1344513cloistered
crispened1443613crispened
distend93312073_disten_d
distended12157923_distended
fastened12257853_fastened
foisted113210603foist__ed
fostered122210453fo_stered
glistered11176293glistered
hastened12239103_hastened
hoidened1335653hoi_dened
hoisted113411293hoist__ed
holstered1345883holstered
hosteled1237283ho_steled
joisted15379173joist__ed
kittened1334523_kittened
leistered1037043leistered
listener8158313_listener
lobstered1244643lobstered
loitered938183loi_tered
loosened945453loos_ened
mastered112614003m_astered
mildened1235773m_ildened
ministered1344963ministered
misatoned1246693m_isatoned
misdeed113211053m_isde_ed
misfeed13389683m_isfe_ed
mispenned1445413m_ispenned
missend104411373m_issen_d
misted93625823m_ist__ed
mistends11419593m_istends
mistermed1438363m_istermed
mistimed1339123m_istimed
mistune9310653m_istune_
mistunes10311133m_istunes
mistyped1685173m_istyped
mitered103213233m_i_tered
moistening1346233moistening
moister94015373moist__er
moistest1038763moiste_st
moistness1146343moistness
moisture1046653moisture_
moistures1147323moistures
morseled1147193mors_eled
moseyed1336133mo_s_eyed
mustered112511503m_ustered
oystered1236923_oystered
poisoned1136953pois_oned
premoistened1752183premoistened
quietened1943353quietened
roisterer946433roisterer
roystered1344873roystered
sistered92612803_sistered
softened1235663so_ftened
whitened1535173whi_tened
worsened1236053wors_ened

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.1561145455.1
2DLD Change Limit148641737.45319943.8
3Display Results73730.0302433.3
 (SQL Overall)178691737.63923391.9
 
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.