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

189 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
carolling125941(None) 
caroling113317001caro_ling
caballing1436882caballing
cajoling18318422cajo_ling
calling103826772ca__lling
canalling1239552canalling
caracolling1643032caracolling
carling103727062car__ling
caroming133312962caro_ming
carousing1237892carousing
carpooling1545022carpooling
cavilling1536392cavilling
drolling103510762_drolling
enrolling1087732enrolling
paroling113316212paro_ling
patrolling1345692patrolling
rerolling102210372rerolling
rolling83620412__rolling
scrolling12187802scrolling
strolling10238792strolling
trolling93212492_trolling
unrolling1078562unrolling
acrolein1045853acrolein_
acroleins1145543acroleins
argling92812733_ar_gling
arousing93811803_arousing
balling104424763ba__lling
bankrolling1852303bankrolling
barreling1238043barreling
barrelling1345453barrelling
bolling103820883__bolling
brailling1247773brailling
broiling113112013_broiling
cabling124017553ca__bling
cackling172610943ca_ckling
cageling12310843ca_geling
calking144617783ca__lking
callings113613833ca__llings
calming123915973ca__lming
calving134113503ca__lving
canaling112016413ca_naling
canceling14310163canceling
cancelling1547213cancelling
candling122313873ca_ndling
canoeing11310213cano_eing
canoodling1443583canoodling
canopying1745063canopying
capellini1345263capellini
caprioling1544523caprioling
capsuling1444533capsuling
caracoling1545633caracoling
carbolizing2545893carbolizing
carding113922443car__ding
careening12310013careening
careering12311203careering
caressing1238803caressing
carhopping2042993carhopping
carillon1046963carillon_
carillons1146363carillons
caring95137993car___ing
carking144322853car__king
carlin84421823car__lin_
carline93923613car__line
carlings114015863car__lings
carlins93921923car__lins
caroli85918233caro_li__
carolled1138833caroll_ed
caroller1039203caroll_er
carollers1137703carollers
carotin92216733caro_tin_
carotins102315583caro_tins
carpeting1439483carpeting
carping123521083car__ping
carroming1437683carroming
carrying14148373car_rying
carting104228283car__ting
cartoning12311113cartoning
cartooning1345883cartooning
carving133916773car__ving
castling11311233ca_stling
catcalling1545123catcalling
catling104819793ca__tling
caulking1536803ca_ulking
caviling14310113ca_viling
cavorting1536063cavorting
celling103921263c__elling
charcoaling1953173charcoaling
chilling143512183c_hilling
chortling1535563chortling
chroming163410723chro_ming
cipollino1342383cipollino
circling1338423cir_cling
coaling103722823c__oaling
codling114418953c__odling
coiling103723453c__oiling
collins93419833c__ollins
collying14319553c__ollying
controlling1445423controlling
cooling103422573c__ooling
coralline1147943coralline
corbeling1439033corbeling
corbelling1546713corbelling
cordelling1446383cordelling
corralling1345433corralling
cowling134017423c__owling
craaling112711353c_raaling
crackling18157003crackling
cradling122411453c_radling
crankling16147293crankling
crawling143110513c_rawling
creeling113513363c_reeling
croaking153712163c_roaking
crocking174313443c_rocking
crooking153611343c_rooking
crooning113112113c_rooning
cropping153210883c_ropping
crossing112612683c_rossing
crowding15247933c_rowding
crowing133814763c_ro_wing
crowning143510033c_rowning
culling103921303c__ulling
cupelling1436283cupelling
cupolaing1443403cupolaing
curdling12228893cur_dling
curling104320183cur__ling
darkling1437483dar_kling
darling93418363dar__ling
dartling1039563dar_tling
dolling93817373__dolling
drilling103311983_drilling
drooling102610423_drooling
earthling1346193earthling
extolling1744623extolling
falling113621583fa__lling
frilling123011493_frilling
galling93921963ga__lling
gambolling1643443gambolling
gaoling93314653ga_o_ling
garbling12249453gar_bling
gargling11239203gar_gling
garoting10510703garo_ting
garotting1136103garotting
gavelling14286873gavelling
grilling103811533_grilling
growling1348163_growling
jackrolling2552043jackrolling
knolling13206893_knolling
labelling1238083labelling
lalling83519623la__lling
laurelling1144463laurelling
logrolling1243063logrolling
lolling83415783__lolling
malling103623663ma__lling
marbling13179883mar_bling
marcelling1545593marcelling
marling103322763mar__ling
marooning1238593marooning
marveling1537103marveling
marvelling1645363marvelling
outrolling1137533outrolling
palling104024483pa__lling
panelling1239073panelling
parboiling1545173parboiling
parceling1438443parceling
parcelling1546173parcelling
parling103823763par__ling
parodying1655423parodying
perilling12410003perilling
polling102920383__polling
prilling113413413_prilling
prowling1449993_prowling
ravelling13269243ravelling
repolling122110203repolling
rilling84023623__rilling
roiling83220453__roiling
rolfing113710653__rolfing
rollings9419953__rollings
shrilling13307693shrilling
thralling13256833thralling
thrilling13276693thrilling
tolling83418563__tolling
trilling92815963_trilling
trollings10286693_trollings
trollying1354053_trollying
varooming1545083varooming
walling113520973wa__lling
warbling14198943war_bling
warsling12198593war_sling
warstling1335063warstling

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.423422437.4
2DLD Change Limit1486411896.51322822.2
3Display Results1891890.0961968.8
 (SQL Overall)1786911897.03225411.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.