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 “capacitates” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
capacitates175301(None) 
capacitate1653451capacitate_
capacitated1852451capacitated
capacitances1751942capacitances
capacities1647692capacit_ies
incapacitates1991752incapacitates
capacitance1651903capacitance
capacitating1952553capacitating
capacitation1854163capacitation
capacitations1953623capacitations
capacitive1953153capacitive_
capacitors1643583capacit_ors
capitate121712183cap__itate_
capitated14159043cap__itated
captivates1745493cap_tivates
cavitates14168963c__avitates
incapacitate1891813incapacitate_
incapacitated2091603incapacitated
rapacities1446543rapacit_ies
acetates102013064___acetates
agitates9310884___agitates
apatites10311294_apa__tites
apocopates1644954_apocopates
apostates1149164_ap_ostates
aspartates1244674aspa_rtates
caducities1544894caducit_ies
calamites13410714calami__tes
calamities1448474calamit_ies
calcites12313004ca_lci__tes
calculates1498704ca_lculates
califates14310114c__alifates
candidates1446304ca_ndidates
capabilities1848824capabilities
capacious1546604capaci__ous
capacitively2452114capacitively
capacitor1543474capaci__tor
capacity1746024capaci__t_y
capiases1239254cap__i_ases
capitals12209444cap__ita_ls
capitulates1554424capitulates
captivate1645924cap_tivate_
captivated1844764cap_tivated
caritases1139754c__aritases
caseinates1247444ca_seinates
castigates1347554ca_stigates
catamites1349364catami__tes
cavitate13159834c__avitate_
cavitated15177354c__avitated
cogitates1247864c__ogitates
covariates1545784covari_ates
craniates11310654c_rani_ates
crepitates1485904c_repitates
decapitates1655644decapitates
deracinates1445864deracinates
emaciates1347884_emaci_ates
expatiates1944894expati_ates
facilitates1644304facilitates
fascinates1547154fa_scinates
felicitates1644204felicitates
glaciates1267344_glaci_ates
gravitates1444844_gravitates
habilitates1673584habilitates
incapacities1853444incapacit_ies
kamacites1744524kamaci__tes
lactates10311224__lac_tates
lancinates1247154la_ncinates
lapidates1247144lap__idates
opacities1347944_opacit_ies
oxalacetates2171154oxalacetates
paginates123111364__paginates
palatinates1344994palatinates
palmitates1445454pa_lmitates
palpitates1445304pa_lpitates
papacies1439474papaci___es
patinates113814694__patinates
pectates122213954__pec_tates
sagacities1345624sagacit_ies
salacities1248234salacit_ies
sanitates9611734__sanitates
speciates13229234_speci_ates
spectates13228814_spec_tates
tractates1159764_trac_tates
triacetates1373404triacetates
vaccinates1746564va_ccinates
vanadiates1443744vanadi_ates
vaticinates1643924vaticinates

Search took 9 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 Filter1786911488190.406440125.6
2DLD Change Limit148819868.42017674.5
3Display Results86860.0461869.6
 (SQL Overall)178691868.87220141.0
 
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.