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

42 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
emendating144461(None) 
emanating1239002eman_ating
emendation1346552emendation
emendations1446052emendations
emending12298892emend__ing
mandating1339772_mandating
amending12308913amend__ing
bendaying1634953_bendaying
cementing1438763cemen__ting
dementing13311043demen__ting
denudating1345263_denudating
elevating1338203ele_vating
elongating1244523elongating
emaciating1546823emaciating
emendate1146783emendat__e
emendated1344663emendat_ed
emendates1246083emendat_es
emendator1244243emendat_or
emendators1344203emendators
emigrating1467503emigrating
emulating1239873em_ulating
enditing10311073__enditing
enervating1488433enervating
eventuating1543253eventuating
execrating2047883execrating
extenuating1943573extenuating
fecundating1852383fecundating
geminating1447763gemin_ating
inundating1244543inundating
medaling121912263_me_daling
mediating13311203_mediating
menacing1339783_men_acing
mending114018683_mend__ing
misdating131010663_misdating
perennating1445543perennating
predating13514653pre_dating
redating102620173_re_dating
remediating1547133remediating
remending132311313remend__ing
sedating103014113_se_dating
sensating1039253_sensating
venenating1446013venen_ating

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 Filter1786911406030.423422437.4
2DLD Change Limit140603426.29622332.1
3Display Results42420.0162625.0
 (SQL Overall)178691426.73526531.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.