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

59 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
deuteric114635(None) 
deuteride1145542deuteride
deuterium1245122deuterium
deuteron946002deuteron
enteric9314212_enteric
neoteric1047852neoteric
aetheric13410163aetheric
butyric1445123_butyric
centric11312403cent_ric
daturic1047033d_aturic
defter104215923defter__
deltaic1037023delt_aic
deltic9312503delt__ic
demerit10314993de_merit
desertic1147743de_sertic
deter65028043de_ter__
deterge9118463de_terge
deters74724683de_ter_s
deuterate1049513deuterate
deuterides1245253deuterides
deuteriums1343693deuteriums
deuterons1046783deuterons
deutzia1743143deut_zia
dexter143810893dexter__
dexterity2044343dexterity
dextrin1587543dext_rin
dietetic1146803dietetic
dimeric12310023d_imeric
dimetric1348663dimetric
dineric10310973d_ineric
diuretic1146993diuretic
dysenteric1652923dysenteric
enterics10312853_enterics
esoteric1057593esoteric
etheric12311783_etheric
eugenic1038603_eugenic
eutectic1245503_eutectic
exoteric1746803exoteric
flueric1246143flu_eric
generic101310753ge_neric
hetaeric1346763hetaeric
hysteric1647533hysteric
icteric1138023_icteric
leucemic1443133leucemic
leukemic1652773leukemic
mesmeric1445813mesmeric
meteoric1247303me_teoric
metric10314683me_t_ric
neotenic1047823neotenic
neoterics1145693neoterics
neuter63713793neuter__
neutered937423neutered
neutering1038963neutering
neuters74212273neuter_s
numeric1158193_numeric
steric8317063__steric
suberic11312213_suberic
ureteric1046243ureteric
uteri51012983__uteri_

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 Filter1786911461620.420425454.8
2DLD Change Limit146162596.53322372.9
3Display Results59590.0301966.7
 (SQL Overall)178691596.98325589.4
 
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.