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 “candidate” 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
candidate135666(None) 
candidates1446301candidates
candida114110252candida__
candidacy1852362candidacy
candidal12367742candida_l
candidas12338652candida_s
candidature1551512candidature
abdicate1348903_abdicate
animate91617213_an_imate
antedate949693_antedate
antidote949723_antidote
bandmate1347973band_mate
califate13310483ca_lifate
candid104517853candid___
candidacies1752703candidacies
candidatures1651623candidatures
candider1237343candid_er
candidest1346533candidest
candidiases1552133candidiases
candidly1545213candid_ly
candids113812693candid__s
cannulate1148633cannulate
cantillate1247343cantillate
canulate10314553can_ulate
capitate121712183ca_pitate
captivate1645923captivate
cardiae10713713cardi_a_e
carinate103320253ca_rinate
caseinate1148243caseinate
castigate1247963castigate
catkinate1545823catkinate
caudate10311353ca__udate
cavitate13159833ca_vitate
cnidae978143c_n_ida_e
confidante1644883confidante
craniate10312563cran_i_ate
cuspidate1443573cuspidate
indicate11313353_indicate
lancinate1147803lancinate
lapidate1157903la_pidate
mandate10315573man__date
manducate1445773manducate
nidate7313783__n_idate
noncandidate1662703noncandidate
pandurate1245883pandurate
radiate83416313ra_di_ate
radicate11412873ra_dicate
sanitate8612043san_itate
syndicate1544513syndicate
validate1239003va_lidate
vanadate1245513van_adate
vanadiate1344443vanadi_ate
vindicate1546353vindicate

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 Limit148641537.36020195.8
3Display Results53530.0134076.9
 (SQL Overall)178691537.79622920.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.