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

178 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
canceling1431016(None) 
cancelling1547211cancelling
aneling82719502_an_eling
angeling102811732_angeling
cackling172610942ca_ckling
cageling12310842ca_geling
canaling112016412can_aling
canalling1239552canalling
candling122313872can_dling
cankering162110792cankering
canoeing11310212canoe_ing
cantering122417372cantering
changeling1745672changeling
channeling1645202channeling
concealing1549302concealing
conceding1559342conceding
hanseling1338062hanseling
paneling111013622pan_eling
parceling1438442parceling
spanceling1543942spanceling
acceding1446093_acceding
angering102113803_angering
angling92816043_an_gling
ankling122912063_an_kling
annealing1047453_annealing
annexing1635473_annexing
anteing8312813_ante_ing
anviling1239743_anviling
atheling1249203_atheling
bannering12208803bannering
bantering122414233bantering
bantling112612003ban_tling
barreling1238043barreling
caballing1436883caballing
cabling124017553ca__bling
cacheting1737153cacheting
caching156317503ca_c_hing
cagelings1335413ca_gelings
cajoling18318423ca_joling
calcining1447813calcining
calling103826773ca__lling
cambering16109873cambering
cameoing1379063ca_meoing
cancel105316683cancel___
canceled13279393cancel_ed
canceler12238913cancel_er
cancelers13247863cancelers
cancelled1456743cancelled
canceller1366683canceller
cancels114113313cancel__s
candying15188993can_dying
caning94128623can___ing
cannelon1045123cannelon_
cannelons1145213cannelons
canning103620133can__ning
cannoning1237323cannoning
canoodling1443583canoodling
canopying1745063canopying
canting104725903can__ting
cantoning12310883cantoning
canvasing1546433canvasing
canyoning1536873canyoning
capelin11510973ca_pelin_
capelins12311133ca_pelins
capering132414963ca_pering
capsuling1444533capsuling
caracoling1545633caracoling
careening12310013careening
careering12311203careering
carling103727063ca__rling
caroling113317003ca_roling
carolling1259413carolling
carpeting1439483carpeting
cascading1545673cascading
casketing1635383casketing
castling11311233ca_stling
catcalling1545123catcalling
catching163712773catc_hing
catering112019903ca_tering
catling104819793ca__tling
caucusing1443803caucusing
caviling14310113ca_viling
cavilling1536383cavilling
centering122915143centering
chancing162810283chanc__ing
chandelling1844453chandelling
changelings1843183changelings
channelling1743993channelling
chiseling1536403chiseling
chuckling2144193chuckling
cinching163310223cinc_hing
cindering13311223cindering
circling1338423circ_ling
coannexing2083163coannexing
cockling172310393c_ockling
concaving1737343concaving
conceiting15311773conceiting
conceiving1846773conceiving
concerning1548903concerning
concerting15313893concerting
concreting1539873concreting
condoling13510373condoling
congealing1447633congealing
congeeing1337903congeeing
consoling12310873consoling
convening15311193convening
conveying1838323conveying
corbeling1439033corbeling
counseling1345463counseling
crackling18157003crackling
cranching17278733cranc_hing
crankling16147293cran_kling
creeling113513363c_reeling
creneling1247733creneling
cudgeling1443663cudgeling
cupeling1338863c_upeling
cycling1537213c_yc_ling
dancing113611563danc__ing
dandering122511063dandering
dandling112511733dan_dling
dangering12239303dangering
dangling112611233dan_gling
eanling81416673ean__ling
enameling1246123enameling
faceting1438783fa_ceting
fancying1735353fanc_ying
flanneling1443813flanneling
funneling1344513funneling
gandering122111293gandering
gangling112411403gan_gling
gaveling133410163ga_veling
hackling183310163ha_ckling
handling132312713han_dling
handseling1544323handseling
hankering17239383hankering
hanselling1445623hanselling
hatcheling1943693hatcheling
hatchling1844953hatchling
jangling17249623jan_gling
kenneling1464083kenneling
kneeling13287783_kneeling
labeling11311643la_beling
lacewing1435843la_cewing
lancing103314123lanc__ing
laureling1035643laureling
mackling172710063ma_ckling
maculing13219583ma_culing
manacling1446283manacling
mangling122312623man_gling
mantling112012613man_tling
marcelling1545593marcelling
marveling1537103marveling
noncling11310763nonc_ling
pancaking1836383pancaking
pandering133211963pandering
panelings12107453pan_elings
panelling1239073panelling
parcelling1546173parcelling
penciling1437413penciling
precanceling1952773precanceling
princeling1544653princeling
ranching141712043ranc_hing
rankling132610113ran_kling
rappeling1435963rappeling
raveling123414373ra_veling
sandaling112010563sandaling
sanderling1256653sanderling
sandling102214413san_dling
scandaling14195453scandaling
scantling12107233scan_tling
spancelling1643343spancelling
tackling153211123ta_ckling
tangling101712543tan_gling
tasseling1035853tasseling
tinseling1036643tinseling
tunneling1034693tunneling
wandering143310983wandering
wangling132310993wan_gling

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.1731032896.0
2DLD Change Limit1486411787.50019818.8
3Display Results1781780.0762342.1
 (SQL Overall)1786911787.74923059.9
 
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.