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

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

57 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
emancipated185287(None) 
emancipate1653541emancipate_
emancipates1753231emancipates
emaciated1446932ema_ci_ated
emancipator1752752emancipator
emaciate1248753ema_ci_ate_
emaciates1347883ema_ci_ates
emanated1139163eman___ated
emancipating1952893emancipating
emancipation1854173emancipation
emancipators1852513emancipators
emasculated1644533emasculated
enunciated1344973enunci_ated
lancinated1345573_lancinated
animated111612374__an_imated
anticipated1665634anticipated
demarcated1645084demarc__ated
deracinated1544864dera_cinated
ejaculated20165904eja_culated
elucidated1464114e_lucidated
emanate9312474eman___ate_
emanates10311334eman___ates
emancipations1953744emancipations
emarginate1385454emarginate_
emasculate1445554emasculate_
emasculates1544904emasculates
emendated1344664emen__dated
enunciate1145744enunci_ate_
enunciates1245134enunci_ates
eradiated11178814era_di_ated
eradicated1446874era_dicated
evacuated15196264eva_c_uated
evaginated1575134eva_ginated
exanimate1845664exan_imate_
fasciated1546134_fasci_ated
fascinated1645874_fascinated
glaciated1365754gla_ci_ated
lancinate1147804_lancinate_
lancinates1247154_lancinates
macerated142010524_ma_cerated
machinated1845664_machinated
maculated142411504_ma_culated
manciple1445094_mancip_le_
manciples1564794_mancip_les
mandated12310294_man__dated
manducated1644564_manducated
manipulated1643964_man_ipulated
marginated14187344_marginated
marinated122513174_ma_rinated
masticated1548234_masticated
quantitated2152924quantitated
reanimated1347004rean_imated
revaccinated20143014revaccinated
sanitated1068994_san_itated
syncopated1853054_syncopated
unanticipated1862244unanticipated
vaccinated1855444_vaccinated

Search took 9 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 Filter1786911488190.436409841.7
2DLD Change Limit148819578.41017695.5
3Display Results57570.0301900.0
 (SQL Overall)178691578.87620131.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.