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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
capitated1415904(None) 
capitate121712181capitate_
cavitated15177351cavitated
agitated1038412_agitated
capacitated1852452capacitated
capitulated1644152capitulated
captivated1844762captivated
carinated123414272carinated
cavitate13159832cavitate_
cavitates14168962cavitates
cogitated1346322cogitated
crepitated1584742crepitated
decapitated1744942decapitated
lapidated1345672lapidated
palpitated1544232palpitated
sanitated1068992sanitated
acetated112010683_acetated
activated1567883activated
agitate8312063_agitate_
agitates9310883_agitates
amputated1444463amputated
animated111612373_animated
aspirated1247703aspirated
aviated11310263_avi_ated
caftaned1445093ca_ftaned
calibrated1545643calibrated
califate13310483califate_
califates14310113califates
canulated12310673canulated
capacitate1653453capacitate_
capacitates1753013capacitates
capiases1239253capi_ases
capita102913773capita___
capital112311523capita__l
capitalised1684853capitalised
capitalized2556473capitalized
capitally1646663capitally
capitals12209453capita_ls
capitation14311363capitation
capitulate1445103capitulate_
capitulates1554423capitulates
capsulated1545653capsulated
captained1446193cap_tained
captioned1445763captioned
captivate1645923captivate_
captivates1745493captivates
captured1336573cap_tured
carinate103320253carinate_
caritases1139763caritases
caseated11310713ca_seated
casemated1446953casemated
castigated1446323castigated
castrated1239513castrated
catenated1238913catenated
catted95422473ca__t_ted
caudated1238063ca_udated
caveated1439133ca_veated
cavitied14126813cavit_ied
ciliated11510953cili_ated
citrated112712253c__itrated
cogitate1148553cogitate_
cogitates1247863cogitates
copulated142710483copulated
corotated122810053corotated
crepitate1385953crepitate_
crepitates1485903crepitates
cristated1247423cristated
decapitate1545873decapitate_
decapitates1655643decapitates
depilated1339653depilated
digitated1286963digitated
epilated11310753_epilated
expiated18168523expi_ated
gravitated1544133gravitated
habituated1643053habituated
hesitated1377783hesitated
imitated1138263_imitated
irritated1076133irritated
labiated11109303labi_ated
lactated1138873la_ctated
laminated122610283laminated
lapidate1157903lapidate_
lapidates1247143lapidates
lariated91212063lari_ated
levitated1346413levitated
marinated122513173marinated
meditated1348083meditated
militated1248803militated
navigated1445483navigated
opiated1039483_opi_ated
oppilated1444583oppilated
paginated13309463paginated
palpitate1365973palpitate_
palpitates1445303palpitates
patinated123911413patinated
pirated102515613__pirated
pitted94319593__pit_ted
radiated102512593radi_ated
radicated13410123radicated
salivated1337473salivated
sanitate8612043sanitate_
sanitates9611733sanitates
saponated1245733saponated
satiated9311603sati_ated
spicated13309903_spicated
spitted103912703_spit_ted
supinated1237883supinated
unpitted1148623unpit_ted
vaginated14328153vaginated
validated1446493validated
variated121211393vari_ated

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 Limit1486411117.25020502.2
3Display Results1111110.0631761.9
 (SQL Overall)1786911117.73623098.6
 
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.