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

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

156 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
captivating194488(None) 
activating1647862_activating
captivation1846172captivation
captivations1945342captivations
castigating1546002castigating
cultivating1744942cultivating
aestivating1545803aestivating
cantillating1565053cantillating
capacitating1952553capacitating
capitulating1773973capitulating
captioning1545703capti_oning
captivate1645923captivat__e
captivated1844763captivat_ed
captivates1745493captivat_es
captivator1743883captivat_or
captivators1853623captivators
captivities1845943captivities
castrating1349773cast_rating
catenating1348683ca_tenating
cavitating1646913ca_vitating
deactivating1953453deactivating
estivating1447633_estivating
inactivating1853463inactivating
lapidating1445243lap_idating
masticating1647833masticating
motivating1646803_motivating
passivating1743783passivating
patinating1339883pa_tinating
reactivating1844753reactivating
salivating1447443sa_livating
satiating10311813sa_ti_ating
titivating1445323_titivating
tittivating1552593tittivating
abdicating1686154_abdicating
acclimating1845294acclimating
acetylating1753284acetylating
activation15610134_activation
activations1669264_activations
activizing2545874_activizing
actuating1239234_act_uating
acuminating1645804acuminating
agitating1138864_a_gitating
animating12312514_a_nimating
antedating1277554_antedating
antiaging1149674_anti_aging
anticaking1747604_anticaking
antidoting1247164_antidoting
antiquating2146434_antiquating
aspirating1348364_aspirating
automating1389304_automating
aviating12311024_a_vi_ating
baptising1446094bapti__sing
baptizing2345844bapti__zing
bastinading1573554bastinading
busticating1645304busticating
cachinnating2092114cachinnating
calculating1666794calculating
calibrating1645354calibrating
camphorating2252564camphorating
cannulating1446014cannulating
canulating1349554ca_nulating
canvasing1546434ca__nvasing
capitation14311364cap_itation
capitations1549854cap_itations
caprioling1544524capri_oling
capsizing2345834capsi__zing
captain112111064capt__a_in_
captaining1546074capt_aining
captains121810574capt__a_ins
captivity1944684captiv__ity
capturing1436624capt__uring
caravaning1644434ca_ravaning
carbonating1645864carbonating
caseating12311744ca__seating
castigation1447974castigation
castigations1547204castigations
catfacing1744554ca_t_facing
cathecting1844834ca_thecting
catting103922644ca_t___ting
cautioning1345724cauti_oning
cavatina1347334ca___vatina
cavatine13310324ca___vatine
caveating1539294ca__veating
cocultivating2162344cocultivating
cogitating1447214c_ogitating
colligating1545714colligating
collimating1645434collimating
complicating2145634complicating
constipating1775394constipating
copulating1549374cop_ulating
crepitating1645804crepitating
criminating1646854criminating
culminating1645734culminating
cultivation16116414cultivation
cultivations1745594cultivations
decapitating1854954decap_itating
depilating1439194dep_ilating
duplicating1745404duplicating
epilating12310974_ep_ilating
estimating1348884_estimating
expatiating2144364expati_ating
expiating1938544exp_i_ating
explicating2356124explicating
fabricating1945034fabricating
fascinating1745254fascinating
festinating1547374festinating
fustigating1654054fustigating
galivanting1642524ga_livanting
gallivanting1751614gallivanting
habituating1743234habituating
implicating1855744implicating
initiating1149624initi_ating
instigating1347154instigating
intimating13410824_intimating
lactating1239194lact__ating
laminating1348734la_minating
lancinating1445454lancinating
lariating10311794la_ri_ating
litigating1246744_litigating
machinating1945624machinating
maltreating1455514maltreating
marginating1545894marginating
marinating13410274ma_rinating
maturating13108574ma_turating
mitigating1447434_mitigating
mutilating1349084_mutilating
navigating1545004na_vigating
nictitating1444384nictitating
opiating11410094_op_i_ating
oppilating1544864_oppilating
paginating1447534pa_ginating
palliating1347894palli_ating
palpitating1644654palpitating
patriating13510204pa_triating
pepsinating1645374pepsinating
pirating11314514__p_irating
pivoting1436184__p_ivoting
quantitating2252924quantitating
radiating111112134ra_di_ating
radicating1459074ra_dicating
recultivating1953014recultivating
remotivating1864334remotivating
replicating1649094replicating
rusticating1446314rusticating
sanitating1149654sa_nitating
saturating11119204sa_turating
scapegoating1851784scapegoating
supinating1357834sup_inating
ultimating1386804_ultimating
uptilting1234714_upti_lting
urticating1347354_urticating
vaccinating1945194vaccinating
validating1545844va_lidating
variating13310954va_ri_ating
ventilating1546344ventilating
vitiating1338414_viti_ating

Search took 10 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.423422437.4
2DLD Change Limit1488191569.34315928.4
3Display Results1561560.1101418.2
 (SQL Overall)1786911569.87618093.5
 
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.