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
cavorters1434961cavorters
aborter939922_aborter
averter102410552_averter
carter84932272ca__rter
cavort11316172cavort__
cavorts1237932cavort_s
favorer1355882favor_er
savorer1057882savor_er
savorier1136642savorier
aborted10310423_aborted
aborters1038563_aborters
accorder1395223accorder
accouter1245363accouter
adopter1036753_adopter
adorer74713443_ador_er
adorner8246973_adorner
alerter72111513_alerter
assorter866663assorter
averted112211613_averted
averters11249503_averters
avoider1155813_avoider
avower1236823_avo_wer
barter85525373ba__rter
cadaster1136893cadaster
cajoler16398393cajo_ler
calorie92716883calorie_
calories102919543calories
calotte9510563calotte_
calottes10610083calottes
caloyer1238143calo_yer
calypter1544063calypter
camcorder1642453camcorder
canister101710853canister
canoer85121073cano__er
canter85230113ca__nter
caperer113013403caper_er
caponier1237883caponier
capote10315733capo_te_
capotes11314643capo_tes
carder94524183ca__rder
career85822243ca__reer
carer74942333ca__r_er
caroler93816753caro_ler
caroller1039203caroller
carouser1068843carouser
carper104923633ca__rper
carrier93619583ca_rrier
carrotier1146623carrotier
carte75940423ca__rte_
carted98631443ca__rted
cartel85022533ca__rtel
carters95327243ca__rters
cartes86239473ca__rtes
carver114420143ca__rver
caster85232573ca__ster
castrater1148523castrater
catbrier1236173catbrier
cater74840703ca___ter
caterer92815933cater_er
catheter1338153catheter
cavalier1348173cavalier
caveated1439133caveated
caveator1387233caveator
caver105629063cav___er
caverned1436163caverned
caviler1249063cav_iler
caviller1337053caviller
cavorting1536063cavorting
charter123918303c_harter
chorten122811303c_horten
chortler13336843c_hortler
clamorer1236903clamor_er
clouter93511683c_louter
coater84329553c__oater
colorer9312523color_er
colter84625093c__olter
comforter16255983comforter
converter14311013converter
cooter85128613c__ooter
copter109822013c__opter
corder94322873c__order
corer75538873c__or_er
corker124720853c__orker
corner84625623c__orner
cortex15311463c__ortex
coster84331293c__oster
cotter84926673c__otter
courter94516463c_ourter
couter84930203c__outer
coverer123113523cover_er
coveter122912063cov_eter
coworker1744683coworker
crofter12299573c_rofter
curter85320073c__urter
darter75320363da__rter
deporter1169393deporter
devouter1235513devouter
diverter12238623diverter
divorcer1444033divorcer
exhorter1845353exhorter
exporter1737363exporter
extorter1546513extorter
fagoter1135883fago_ter
favored1455983favor_ed
favorers1465493favor_ers
favorite1447313favorite_
favorites1546583favorites
favourer1443823favourer
flavorer1454553flavor_er
garotter965943garotter
garroter956573garroter
garter74420513ga__rter
gavotte1174603gavotte_
gavotted1363343gavotted
gavottes1274183gavottes
havocker2042393havocker
importer12308913importer
inverter112411073inverter
laborer9249503labor_er
parroter1058203parroter
porter84224413__porter
reporter10411423reporter
resorter8312173resorter
retorter8410733retorter
reverter114812873reverter
revolter11279363revolter
savored1158343savor_ed
savorers1157223savor_ers
savories11311273savories
savourer1134473savourer
savourier1242973savourier
shorter103515493_shorter
snorter74412653_snorter
sorter64425083__sorter
sporter93616553_sporter
taborer9269293tabor_er
tarter64023563ta__rter
taverner1134423taverner
vaporer1236983vapor_er
vortex1635923__vortex
voter85121053__vo_ter
waverer13319523waver_er

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621448.40617387.8
3Display Results1441440.0463130.4
 (SQL Overall)1786911448.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.