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

50 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
extricate186907(None) 
extricated2067081extricated
extricates1998241extricates
explicate20117492explicate
extirpate1844022extirpate
extricable2144742extricable
intricate11411192intricate
metricate1349922metricate
affricate1744973affricate
corticate13410763corticate
elutriate945303elutri_ate
embrocate1565523embrocate
entrecote1144483entrecote
eradicate1259183eradicate
estimate10912003est_imate
estivate111010003est_ivate
exanimate1845663exanimate
exarchate2144453exarchate
excoriate1846883excori_ate
excruciate2152883excruciate
expatriate1954043expatri_ate
expiate16910593ex_pi_ate
explicated22106103explicated
explicates2196663explicates
exsiccate2043143exsiccate
extenuate1645003extenuate
exterminate2054543exterminate
extirpated2043123extirpated
extirpates1943683extirpates
extract16311013extrac_t_
extracted1946723extrac_ted
extracts1747623extrac_ts
extradite1746433extradite
extricating2146693extricating
extrication2049793extrication
extubate1745103ext_ubate
exuviate1846063exuvi_ate
fabricate1646833fabricate
imbricate1545663imbricate
loricate10310663_loricate
lubricate1346443lubricate
metricated1547303metricated
metricates1449123metricates
muricate12311113_muricate
patriate10311933patri_ate
patriciate1446323patriciate
rubricate1346483rubricate
striate74218953_stri_ate
suricate10312613_suricate
urticate1049863urt_icate

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 Filter1786911486410.436409841.7
2DLD Change Limit148641507.12620859.0
3Display Results50500.0163125.0
 (SQL Overall)178691507.57823580.2
 
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.