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

53 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
exocrine174599(None) 
exocrines1845481exocrines
apocrine1246932apocrine
eccrine1137282e_ccrine
endocrine1246182endocrine
exorcise1745932exorcise
exorcize2644892exorcize
merocrine1346232merocrine
autocrine1146613autocrine
chorine123218363cho_rine
cocaine111315173_cocaine
croceine1248033croceine
crocine11314153croc_ine
dextrine1688253dex_trine
doctrine1146733_doctrine
dourine8311453_dourine
ecocide1246743ecoc_ide
encoring11312173encoring
endocrines1365523endocrines
enshrine1147263enshrine
eocene8311613e_oc_ene
eosine64519413e_o_sine
eserine7415903e_serine
eucaine939243e_ucaine
eucrite939903e_ucrite
exacting1838523exacting
examine161510033ex_amine
excide1638423ex_c_ide
excise1538553ex_c_ise
excite15310883ex_c_ite
excoriate1846883excoriate
excrete1667163ex_crete
execrate1739653execrate
exercise1747063exercise
exine125518493ex___ine
exorcised1944363exorcised
exorciser1843743exorciser
exorcises1845693exorcises
exorcism1945203exorcism
exorcist1746873exorcist
exorcized2843753exorcized
exorcizes2744253exorcizes
expiring1836253expiring
exscind1743753exsc_ind
extermine1848283extermine
externe1438573exter_ne
holocrine1495343holocrine
isocline1047293isocline
leporine1049303lepo_rine
phocine1438833phoc_ine
porcine11312843_porcine
procaine12312273procaine
tacrine9311293_tacrine

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.423422437.4
2DLD Change Limit146162536.37322934.6
3Display Results53530.0163312.5
 (SQL Overall)178691536.81226231.8
 
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.