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

123 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
caballing143688(None) 
canalling1239551canalling
balling104424762__balling
cabling124017552cab__ling
calling103826772c__alling
canaling112016412cana_ling
carolling1259412carolling
catcalling1545122catcalling
cavilling1536382cavilling
labelling1238082labelling
abashing1466623_abashing
abasing10610673_aba_sing
abating10413973_aba_ting
ablating11311993_ablating
appalling1444923appalling
availing1267283_availing
babbling12228693bab_bling
bailing103723523__bailing
balding114015063__balding
baling94829693__ba_ling
balking143717353__balking
bawling133813863__bawling
befalling15226503befalling
begalling13216493begalling
belling103825073__belling
billing103823853__billing
bolling103820883__bolling
bulling104324793__bulling
cabalism14310143caba_lism
cabalist12314503caba_list
caballed1337163caball_ed
caballero1342883caballero
cabbaging1744093cabbaging
cabbing143613153cab__bing
cabining1338643cab_ining
cackling172610943ca_ckling
cageling12310843ca_geling
cajoling18318423ca_joling
calking144617783c__alking
callings113613833c__allings
calming123915973c__alming
calving134113503c__alving
canalising1349363canalising
canalizing22410423canalizing
canceling14310163canceling
cancelling1547213cancelling
candling122313873ca_ndling
capellini1345263capellini
capsuling1444533capsuling
caracoling1545633caracoling
caracolling1643033caracolling
carling103727063c__arling
caroling113317003ca_roling
castling11311233ca_stling
cataloging1444953cataloging
catalyzing2544773catalyzing
catling104819793c__atling
caulking1536803ca_ulking
cavallies1446393cavallies
caviling14310113ca_viling
celling103921263c__elling
chalking183310063c_halking
chilling143512183c_hilling
coaling103722823c_oa_ling
cobaltine13135613cobaltine
cobbling15248803cob_bling
coralline1147943coralline
corbelling1546713corbelling
corralling1345433corralling
craaling112711353c_raaling
cradling122411453c_radling
crawling143110513c_rawling
culling103921303c__ulling
cupelling1436283cupelling
dabbling14227973dab_bling
dialling10310783_dialling
embalming1644263embalming
equalling1945243equalling
eyeballing1642263eyeballing
fabling133413623fab__ling
falling113621583__falling
gabbling14238073gab_bling
gabling113514543gab__ling
galling93921963__galling
gambolling1643443gambolling
gavelling14286873gavelling
gimballing16202923gimballing
imbalming1643723imbalming
infalling1356243infalling
inwalling1385633inwalling
labeling11311643lab_eling
lalling83519623__lalling
libelling1236873libelling
lowballing1642273lowballing
malling103623663__malling
manacling1446283manacling
medalling1346923medalling
metalling1249593metalling
napalming1443173napalming
palling104024483__palling
panelling1239073panelling
pedalling1346663pedalling
pinballing1544013pinballing
rabbling13239333rab_bling
ravelling13269243ravelling
rebelling122111163rebelling
rebilling12228833rebilling
recalling122211903recalling
refalling132010423refalling
rivalling1335963rivalling
sandalling1245873sandalling
scabbling1634863scab_bling
scandalling1543443scandalling
spalling113213463_spalling
squalling1935173squalling
stalling95116703_stalling
tabling103216033tab__ling
thralling13256833thralling
totalling1036523totalling
unbaling11310683unba_ling
vialling1237223_vialling
wabbling16207743wab_bling
walling113520973__walling

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.846211218.7
2DLD Change Limit1486411236.93621430.4
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.82822827.2
 
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.