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

144 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
cavorter133578(None) 
cavorted1435691cavorted
cavorters1434971cavorters
aborter939932_aborter
averter102410552_averter
carter84932272ca__rter
cavort11316172cavort__
cavorts1237932cavort_s
favorer1355882favor_er
savorer1057882savor_er
savorier1136642savorier
aborted10310423_aborted
aborters1038573_aborters
accorder1395253accorder
accouter1245363accouter
adopter1036763_adopter
adorer74713453_ador_er
adorner8246983_adorner
alerter72111513_alerter
assorter866673assorter
averted112211613_averted
averters11249513_averters
avoider1155813_avoider
avower1236823_avo_wer
barter85525373ba__rter
cadaster1136903cadaster
cajoler16398393cajo_ler
calorie92716903calorie_
calories102919563calories
calotte9510563calotte_
calottes10610083calottes
caloyer1238143calo_yer
calypter1544063calypter
camcorder1642463camcorder
canister101710853canister
canoer85121073cano__er
canter85230113ca__nter
caperer113013403caper_er
caponier1237883caponier
capote10315733capo_te_
capotes11314643capo_tes
carder94524183ca__rder
career85822243ca__reer
carer74942333ca__r_er
caroler93816753caro_ler
caroller1039203caroller
carouser1068853carouser
carper104923633ca__rper
carrier93619583ca_rrier
carrotier1146623carrotier
carte75940423ca__rte_
carted98631443ca__rted
cartel85022533ca__rtel
carters95327253ca__rters
cartes86239473ca__rtes
carver114420153ca__rver
caster85232573ca__ster
castrater1148523castrater
catbrier1236173catbrier
cater74840723ca___ter
caterer92815943cater_er
catheter1338153catheter
cavalier1348183cavalier
caveated1439133caveated
caveator1387233caveator
caver105629063cav___er
caverned1436163caverned
caviler1249063cav_iler
caviller1337063caviller
cavorting1536063cavorting
charter123918303c_harter
chorten122811303c_horten
chortler13336843c_hortler
clamorer1236913clamor_er
clouter93511693c_louter
coater84329573c__oater
colorer9312523color_er
colter84625093c__olter
comforter16255983comforter
converter14311013converter
cooter85128613c__ooter
copter109822013c__opter
corder94322883c__order
corer75538873c__or_er
corker124720853c__orker
corner84625623c__orner
cortex15311473c__ortex
coster84331293c__oster
cotter84926673c__otter
courter94516483c_ourter
couter84930223c__outer
coverer123113523cover_er
coveter122912063cov_eter
coworker1744683coworker
crofter12299573c_rofter
curter85320083c__urter
darter75320363da__rter
deporter1169393deporter
devouter1235513devouter
diverter12238623diverter
divorcer1444033divorcer
exhorter1845353exhorter
exporter1737363exporter
extorter1546513extorter
fagoter1135883fago_ter
favored1455983favor_ed
favorers1465493favor_ers
favorite1447313favorite_
favorites1546583favorites
favourer1443823favourer
flavorer1454563flavor_er
garotter965943garotter
garroter956573garroter
garter74420513ga__rter
gavotte1174603gavotte_
gavotted1363343gavotted
gavottes1274183gavottes
havocker2042393havocker
importer12308913importer
inverter112411073inverter
laborer9249513labor_er
parroter1058203parroter
porter84224413__porter
reporter10411423reporter
resorter8312183resorter
retorter8410733retorter
reverter114812873reverter
revolter11279363revolter
savored1158343savor_ed
savorers1157223savor_ers
savories11311273savories
savourer1134473savourer
savourier1242973savourier
shorter103515503_shorter
snorter74412663_snorter
sorter64425093__sorter
sporter93616553_sporter
taborer9269293tabor_er
tarter64023563ta__rter
taverner1134423taverner
vaporer1236983vapor_er
vortex1635923__vortex
voter85121053__vo_ter
waverer13319523waver_er

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.406440125.6
2DLD Change Limit1461621446.70321805.5
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.17224915.1
 
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.