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

54 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
vindicate154635(None) 
indicate11313351_indicate
vindicated1745121vindicated
vindicates1646091vindicates
indicated13310952_indicated
indicates12312582_indicates
syndicate1544512syndicate
vindicable1843902vindicable
vindicative2053792vindicative
vindicator1644512vindicator
abdicate1348903_abdicate
candidate1356663candidate
dedicate12312803_dedicate
eradicate1259183eradicate
indagate1047193_indagate
indelicate1345933_indelicate
indican1048243_indica_n
indicans1147663_indicans
indicant11410343_indicant
indicants1247203_indicants
indicative1647713_indicative
indicator1249013_indicator
indict93115573_indic_t_
indicted1249203_indic_ted
indictee1149623_indictee
indicter1148143_indic_ter
indicts103210723_indic_ts
indite73520323_indi__te
indurate9311873_indurate
intimate101013833_intimate
intricate11411193_intricate
invocate1347833_invocate
iodinate949343_iodinate
manducate1445773manducate
medicate13513243_medicate
predicate14411783predicate
radicate11412873_radicate
silicate10312623si_licate
sonicate10310933son_icate
syndicated1743743syndicated
syndicates1644473syndicates
tunicate103310043tun_icate
vanadiate1344443vanadi_ate
vellicate1446433vellicate
ventilate1248383ventilate
vesicate131210053v_esicate
vindicating1844643vindicating
vindication1746353vindication
vindicators1744533vindicators
vindicatory2053393vindicatory
vindictive1943543vindictive
vitiate103412953vi_ti_ate
vizirate2045353vi_zirate
zincate1838533zin__cate

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.423422437.4
2DLD Change Limit148641547.09320956.0
3Display Results54540.0163375.0
 (SQL Overall)178691547.53223724.2
 
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.