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

89 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
echinate135940(None) 
echinated1546481echinated
echidnae1442902echidna_e
echinacea1651922echinacea
machinate1647952machinate
pectinate1349552pectinate
reclinate11410022reclinate
achiote1239213achi_ote
activate13510373activate
acuminate1347573acuminate
agminate1139243agminate
alginate9310693alginate
binate8419773__binate
cachinnate1752563cachinnate
carinate103320243carinate
celibate1259313celibate
chelate122914893_chelate
chianti1236603_chianti
chicane1489553_chicane
china105022473_china__
chinas115119383_china_s
chine105231723_chin__e
chinone12510153_chinone
chints115117833_chin_ts
chintz204212023_chin_tz
cholate122114933_cholate
climate11312833_climate
cognate10312193_cognate
coinage10310553_coinage
coinmate1239053_coinmate
connate9315753_connate
crenate93317113_crenate
crinite9513633_crinite
cyanate12259703_cyanate
deaminate12410173deaminate
decimate13411123dec_imate
dominate11312853dominate
ecaudate1145313ecaudate
echidna1343723echidna__
echidnas1443383echidna_s
echinaceas1751723echinaceas
eching126315563echin__g
echini114710433echin__i
echinoid1445993echinoid
echinus1236203echin_us
eliminate1147733eliminate
emanate9312473e_manate
emirate91015833e_mirate
enate54428143e___nate
enceinte1046263encein_te
encrinite1146043encrinite
ephorate1359503ephorate
epilate9314283e_pilate
estimate10912003estimate
estivate111010003estivate
ethylate1446213ethylate
evaginate1376483evaginate
expiate16910593expi_ate
festinate1249473festinate
geminate11411793geminate
germinate1248623germinate
ichnite1245983ich_nite
iodinate949343iodinate
khanate1437073_khanate
laminate103014633laminate
machinated1845663machinated
machinates1747323machinates
marinate103017783marinate
nominate10312473nominate
ordinate9310253ordinate
paginate114012443paginate
patinate103016313patinate
pepsinate1346633pepsinate
phenate12412193_phenate
phonate12411813_phonate
quinate16511573_quinate
recoinage1245643recoinage
resinate8316773resinate
ruinate7312833_ruinate
ruminate10511473ruminate
spinate93114813_spinate
succinate1346683succinate
supinate10310313supinate
terminate11411203terminate
thionate11137493_thionate
uncinate10312393uncinate
urinate7315363_urinate
vaccinate1646833vaccinate
vaginate123911083vaginate

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 Filter1786911461620.330541487.9
2DLD Change Limit146162898.45017297.3
3Display Results89890.0332697.0
 (SQL Overall)178691898.81320275.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.