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

95 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
abdicate134890(None) 
abdicated1547011abdicated
abdicates1448151abdicates
abdicable1685022abdicable
abdicator1446262abdicator
dedicate12312802dedicate
fabricate1646832fabricate
indicate11313352indicate
medicate13513242medicate
radicate11412872radicate
abate76627843ab___ate
abdicating1686153abdicating
abdication1548223abdication
abdicators1546263abdicators
abduce1197193abduc__e
abduct11108543abduc_t_
abducted1444093abduc_ted
abductee1344783abductee
abducts1265313abduc_ts
ablate82219213ab__late
ablegate1147253ablegate
abnegate1144863abnegate
abominate1347023abominate
abrogate11129603abrogate
activate13510373activate
addict10711203addic_t_
addicted1345073addic_ted
addicts1176013addic_ts
adjudicate2152263adjudicate
adnate72913483a_d_nate
adulate8313233a_dulate
aduncate1145573aduncate
advocate1445833advocate
affricate1744973affricate
agitate8312063a_gitate
agminate1139243agminate
aguacate1144973aguacate
aldicarb1342903aldicarb
alginate9310693alginate
allocate10411023allocate
amirate91115953a_mirate
animate91617213a_nimate
aspirate1039943aspirate
auspicate1345743auspicate
aviate9315203a_vi_ate
baccate131011263_baccate
badinage1294923badinage
binate8419773_b_inate
candidate1356663candidate
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicates13311693dedicates
delicate11315493delicate
dictate10311663__dictate
dilate73220693__dilate
educate10310213_educate
eradicate1259183eradicate
fabricated1845403fabricated
fabricates1746463fabricates
imbricate1545663imbricate
indicated13310953indicated
indicates12312583indicates
iodinate949343iodinate
labiate91313573lab_i_ate
loricate10310663loricate
lubricate1346443lubricate
manducate1445773manducate
masticate13411283masticate
mediate103415213medi_ate
medicare1347483medicare
medicated15410073medicated
medicates14312113medicates
meditate11310623meditate
muricate12311113muricate
obdurate1175123obdurate
obligate11198303obligate
obviate1235783obvi_ate
ordinate9310253ordinate
plicate11314513_plicate
predicate14411773predicate
rabbinate1345143rabbinate
radiate83416313radi_ate
radicated13410123radicated
radicates12412073radicates
redictate1249063redictate
rubricate1346483rubricate
silicate10312623silicate
sonicate10310933sonicate
spicate113214193_spicate
suricate10312613suricate
syndicate1544513syndicate
tunicate103310043tunicate
urticate1049863urticate
vesicate131210053vesicate
vindicate1546353vindicate

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.436409841.7
2DLD Change Limit146162956.50022486.5
3Display Results95950.0303166.7
 (SQL Overall)178691956.96625651.9
 
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.