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

168 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
cavorted143569(None) 
cavorter1335781cavorter
aborted10310422_aborted
averted112211612_averted
carted98631442ca__rted
caveated1439132caveated
caverned1436162caverned
cavort11316172cavort__
cavorters1434972cavorters
cavorts1237932cavort_s
favored1455982favor_ed
gavotted1363342gavotted
savored1158342savor_ed
aborter939933_aborter
accorded14155363accorded
accosted1345533accosted
acorned10238283_acorned
adopted1136253_adopted
adored84714243_ador_ed
adorned9256893_adorned
adverted1336103adverted
airted74214503_a_irted
alerted82512223_alerted
assorted956603assorted
averred11237593_averred
averter102410553_averter
aviated11310263_aviated
avoided1235553_avoided
avowed1335963_avo_wed
azoted16388593_azo_ted
caboched1844043caboched
caboshed1634393caboshed
cacheted16148233cacheted
cairned1037643ca_irned
cajoled17428283cajo_led
calorie92716903calorie_
calories102919563calories
calorized21249673calorized
calotte9510563calotte_
calottes10610083calottes
canoed94618963cano__ed
canopied1336353canopied
canted94825783ca__nted
capered123014043caper_ed
capote10315733capo_te_
capotes11314643capo_tes
carded105424903ca__rded
cared86050093ca__r_ed
caried94528693ca__ried
carked134024823ca__rked
caroled103717693caro_led
carolled1138833carolled
caromed123713623caro_med
carotid102014833caro_tid
caroused1149263caroused
carped115923763ca__rped
carpeted1338953carpeted
carried103717153ca_rried
carromed1338573carromed
carte75940423ca__rte_
cartel85022533ca__rtel
carter84932273ca__rter
cartes86239473ca__rtes
carved124320853ca__rved
caseated11310713caseated
casketed1534953casketed
castrated1239523castrated
catered103117783cater_ed
catted95422473ca__tted
caudated1238063caudated
caved116227563cav___ed
caviled1348723cav_iled
cavilled1436733cavilled
cavitated15177353cavitated
cavitied14126813cavitied
cavorting1536063cavorting
charted135116853c_harted
chorded144710553c_horded
chored125321883c_hor_ed
chorten122811303c_horten
chortled14326613c_hortled
clamored1336953clamor_ed
clavered14187633claver_ed
clotted104011823c_lotted
clouted104212163c_louted
coated94927043c__oated
cohosted1436143cohosted
colored10313473color_ed
comforted17315963comforted
comported16319533comported
consorted1239773consorted
contorted1239483contorted
converted15311563converted
coopted123710773c_oopted
corded105923353c__orded
cored85044223c__or_ed
corked135020783c__orked
corned95224523c__orned
cortex15311473c__ortex
costed95623123c__osted
coted85033853c__o_ted
courted103514923c_ourted
covaried1448003covaried
covered133315293cover_ed
coveted133011523cov_eted
darted84620923da__rted
dehorted1357303dehorted
deported1249703deported
devoted124111093devo_ted
diverted13199583diverted
divorced1544313divorced
escorted1136703escorted
everted112711853_everted
exhorted1935013exhorted
exported1837133exported
extorted1636233extorted
fagoted1236073fago_ted
farted105121783fa__rted
favorer1355883favor_er
favorite1447313favorite_
favorites1546583favorites
favoured1533963favoured
flavored1554583flavor_ed
garoted9710133garo_ted
garotted1066193garotted
garroted1056793garroted
gavotte1174603gavotte_
gavottes1274183gavottes
havered144011453haver_ed
havocked2142323havocked
imported13308693imported
intorted9310123intorted
inverted122312163inverted
labored102810253labor_ed
majored1735853major_ed
marted94425213ma__rted
obverted1435103obverted
parroted1158853parroted
parted94228683pa__rted
pivoted1336513pivo_ted
ported94223243__ported
ragouted1034423ragouted
razored1736333razor_ed
reported11312703reported
resorted9313493resorted
retorted9312333retorted
reverted122714713reverted
revolted12319863revolted
revoted114314153revo_ted
savorer1057883savor_er
savorier1136643savorier
savories11311273savories
savoured1234793savoured
scarted104816123sca__rted
shorted113614403_shorted
snorted83813493_snorted
sorted74523713__sorted
sported104015433_sported
tabored102810563tabor_ed
tarted74923373ta__rted
unaborted1245733unaborted
unaverted1336563unaverted
unsorted9312513unsorted
vapored1336923vapor_ed
vortex1635923__vortex
voted93919143__vo_ted
warted104223233wa__rted
wavered142910433waver_ed

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621686.81321453.4
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.29924481.6
 
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.