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

145 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
cavorting153606(None) 
aborting11710252_aborting
averting122512732_averting
carting104228282ca__rting
caveating1539292caveating
caverning1536282caverning
favoring1596672favor_ing
gavotting1443192gavotting
savoring1269482savor_ing
aborning1188003_aborning
according1545273according
accosting1446733accosting
adopting1237453_adopting
adoring9412523_ador_ing
adorning1087323_adorning
adverting1437223adverting
airting83616303_a_irting
alerting91312383_alerting
assorting1037303assorting
averring12239063_averring
aviating12311023_aviating
avoiding1336783_avoiding
avowing1466603_avo_wing
cacheting1737153cacheting
cajoling18318423cajo_ling
calorizing2248593calorizing
canoeing11310213cano_eing
canopying1745063canopying
canting104725903ca__nting
capering132414963caper_ing
carding113922443ca__rding
caring95137993ca__r_ing
carking144322853ca__rking
carling103727063ca__rling
caroling113317003caro_ling
carolling1259413carolling
caroming133312963caro_ming
carotin92216733caro_tin_
carotins102315583caro_tins
carousing1237893carousing
carpeting1439483carpeting
carping123521083ca__rping
carroming1437683carroming
carrotin102210893carrotin_
carrotins11239963carrotins
carrying14148373ca_rrying
carving133916773ca__rving
caseating12311743caseating
casketing1635383casketing
casting104628343ca__sting
castrating1349773castrating
catering112019913cater_ing
catting103922643ca__tting
cavatina1347333cav_atina
cavatine13310323cav_atine
caviling14310113cav_iling
cavilling1536393cavilling
caving124822613cav___ing
cavitating1646913cavitating
cavort11316173cavort___
cavorted1435693cavort_ed
cavorter1335783cavort_er
cavorters1434973cavorters
cavorts1237933cavort__s
charting142614193c_harting
chording15410153c_hording
choring133617663c_hor_ing
chortling1535563c_hortling
clamoring1477423clamor_ing
clavering1538373claver_ing
clotting113110643c_lotting
clouting113011683c_louting
coating103525313c__oating
cohosting1546323cohosting
coloring11414843color_ing
comforting18165933comforting
comporting17199163comporting
consorting13410743consorting
contorting13410103contorting
converting16313133converting
coopting133411313c_oopting
cording113620823c__ording
coring94433963c__or_ing
corking143018823c__orking
corning103720133c__orning
cortin82423153c__ortin_
cortina91915973c__ortina
cortins92421333c__ortins
costing104323023c__osting
coting94629253c__o_ting
courting112514573c_ourting
covarying1844133covarying
covering142215733cover_ing
coveting141912313cov_eting
darting94020663da__rting
dehorting1447213dehorting
deporting1369593deporting
devoting1338823devo_ting
diverting142410333diverting
divorcing1644323divorcing
escorting1237713escorting
everting122213133_everting
exhorting2045733exhorting
exporting1937323exporting
extorting1746763extorting
fagoting1336283fago_ting
farting114120753fa__rting
favouring1644023favouring
flavoring1665113flavor_ing
garoting10510703garo_ting
garotting1136113garotting
garroting1136953garroting
havering152211053haver_ing
havocking2242773havocking
importing1438193importing
intorting10311413intorting
inverting131013223inverting
karting123716063ka__rting
laboring112110143labor_ing
majoring1836363major_ing
marting103325013ma__rting
obverting1536303obverting
parroting1239153parroting
parting103527383pa__rting
pivoting1436183pivo_ting
porting103021783__porting
ragouting1134893ragouting
razoring1836443razor_ing
reporting12513903reporting
resorting10614613resorting
retorting10613273retorting
reverting132315133reverting
revolting1339633revolting
revoting12312033revo_ting
savouring1335193savouring
scarting113415263sca__rting
shorting122514803_shorting
snorting92613373_snorting
sorting83221813__sorting
sporting112415463_sporting
taboring113010193tabor_ing
tarting84222653ta__rting
vaporing1437653vapor_ing
voting103916033__vo_ting
wavering152410543waver_ing

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.406440125.6
2DLD Change Limit1486411456.78021923.5
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.24924650.4
 
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.