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

103 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
answered123549(None) 
answerer1144271answerer
angered93013472an_gered
answer936892answer__
answerers1243742answerers
answers1037042answer_s
antlered938262antlered
unanswered1443022unanswered
absterged1353353absterged
adhered1239233a_dhered
altered83215733a_ltered
anchored1438593anchored
aneared8512743an_eared
aneled74719283an__eled
angeled93211513an_geled
aniseed839403anise_ed
annexed1535753an_nexed
ansated84214003ans_ated
answering1345803answering
anteed75616113an_te_ed
anthemed1446953anthemed
antherid12611093antherid
antired82316193an_tired
antiweed1246303antiwe_ed
anywhere1742563anywhere_
anywheres1842343anywheres
ascared10399523a_scared
ashlered1244623ashlered
aspersed11428293a_spersed
aspired1068173a_spired
asserted957903a_sserted
assured858373a_ssured
asswaged1343333asswaged
austere7312993austere_
austerer838383austerer
axseed1456993axs_e_ed
banistered1394623banistered
bannered11299323ban_nered
bantered113313633ban_tered
bistered112913323bistered
bowered133113043_bowered
cancered132411553can_cered
cankered153010223can_kered
cantered113415983can_tered
coshered14610293coshered
cowered133214653_cowered
dandered112110963dan_dered
daneweed1344053danewe_ed
dangered11248513dan_gered
dowered122811553_dowered
enserfed1245193ens_erfed
ensnared965293ensnared
ensphered1565283ensphered
ensured83512943ens_ured
entered82718883en_tered
festered122512103festered
flowered1546013flowered
fostered122210453fostered
gandered112211173gan_dered
glowered1345753glowered
hankered16289443han_kered
hanseled1237713hans_eled
inhered11313163in_hered
inserted92413053ins_erted
insnared956123insnared
insphered1564783insphered
inspired1136273inspired
insured83714253ins_ured
kashered1636403kashered
koshered1636063koshered
lowered112711913_lowered
lustered92510603lustered
mannered11249653man_nered
mastered112614003mastered
mustered112511503mustered
nattered92011623nattered
osiered837123_osiered
oystered1236923oystered
pandered121812573pan_dered
panniered1243853panniered
pestered112814963pestered
powered132911643_powered
sered65737293__s_ered
sewered112911243_sewered
showered1537013showered
sistered92612803sistered
skewered1634213skewered
sneered83113973sn_eered
swerved1455703__swerved
towered112911403_towered
unseared91113943unseared
unseeded1038253unseeded
unserved12410233uns_erved
unsewed112911023uns_ewed
unsexed152410253uns_exed
unshared121510703unshared
unsoured9310063unsoured
unsphered1556103unsphered
unswayed15155713unswayed
unswore1039053unswore_
ushered1139153_ushered
wandered132110793wan_dered
westered122511863westered

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.403443402.0
2DLD Change Limit1461621036.72021750.3
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.16924925.5
 
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.