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

58 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
deuterated124753(None) 
deuterate1049511deuterate_
deuterates1149081deuterates
deaerated11311112de_aerated
reiterated11410152reiterated
adulterated1353503adulterated
deaerate9314173de_aerate_
deaerates10313643de_aerates
decelerated1545923decelerated
decorated13312203de_corated
defeated132812163de_fe_ated
defecated1637493de_fecated
degenerated1445743degenerated
dehydrated1943493dehydrated
delegated1238373de_legated
deliberated1545633deliberated
demerited1339073de_merited
denervated1545113de_nervated
denigrated1366973denigrated
denitrated1298033denitrated
dentated10411703dent__ated
deprecated1646673deprecated
depredated1544813depredated
depurated1338183de_purated
derated93623503d___erated
desecrated1447953desecrated
deserted101012203de_ser_ted
desiderated1444943desiderated
desperate12410843desperate_
detected12289733de_te_cted
deterged11127923de_ter_ged
deterred10137803de_ter_red
detested10279623de_te_sted
detonated1138213de_tonated
detracted1357793de_t_racted
deuterating1347273deuterating
deuteration1249103deuteration
deuteride1145543deuteride_
deuterides1245253deuterides
entreated10310973_entreated
enumerated13125783enumerated
estreated1039563_estreated
exenterated1964793exenterated
exuberated2044493exuberated
federated1438423fe_derated
generated11310203ge_nerated
iterated91213823__iterated
neutered937423neuter__ed
numerated12177873_numerated
outrated92219313_out_rated
penetrated1347303penetrated
recuperated1645173recuperated
reiterate9412933reiterate_
reiterates10412003reiterates
remunerated1475353remunerated
reoperated1348153reoperated
retreated10312623re_treated
venerated1339953ve_nerated

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 Filter1786911406030.406440125.6
2DLD Change Limit140603586.56321423.6
3Display Results58580.0331757.6
 (SQL Overall)178691587.00225520.0
 
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.