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

314 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
canoeing1131021(None) 
anteing8312812_anteing
cajoling18318422cajoling
cameoing1379062cameoing
canaling112016412canaling
canceling14310162canceling
candling122313872candling
candying15188992candying
caning94128622can__ing
cankering162110792cankering
canning103620132can_ning
cannoning1237322cannoning
canoeist10310692canoeist
canopying1745062canopying
cantering122417372cantering
canting104725902can_ting
cantoning12310882cantoning
canyoning1536872canyoning
caroling113317002caroling
caroming133312962caroming
aboding11410123_aboding
adoring9412523_adoring
ageing84213403_a_geing
aneling82719503_aneling
angeling102811733_angeling
angering102113803_angering
angling92816043_angling
ankling122912063_ankling
annexing1635473_annexing
annoying1246543annoying
anoint6423633_ano_int
anting75827023_an_ting
atoning83514873_atoning
avowing1466603_avowing
aweing103911253_a_weing
banding114921413ban_ding
bandying15218073bandying
banging114019863ban_ging
baning95127833ban__ing
banking144621353ban_king
bannering12208803bannering
banning103818233ban_ning
banteng1046363bante_ng
bantering122414233bantering
bantling112612003bantling
bingeing12237643bingeing
cabbing143613153ca_bbing
cabining1338643cabining
cabling124017553ca_bling
cacheting1737153cacheting
caching156317503ca_ching
cackling172610943cackling
caddying16225063caddying
cadging123610973ca_dging
caffein1535333caffein_
caffeine1644513caffeine
caffeins1645123caffeins
cageling12310843cageling
caging105321023ca__ging
caking134624673ca__king
calking144617783ca_lking
calling103826773ca_lling
calming123915973ca_lming
calquing2035593calquing
calving134113503ca_lving
cambering16109873cambering
camping143118973ca_mping
canakin131810833canakin_
canakins142010463canakins
canalling1239553canalling
cancelling1547213cancelling
candent10417363cande_nt
canikin13189753canikin_
canikins14219163canikins
canine83826703can__ine
cannings113710333can_nings
canoe75627253canoe___
canoed94618963canoe__d
canoeists1147163canoeists
canoer85121073canoe__r
canoers94318373canoe_rs
canoes84725883canoe__s
canon74725303cano__n_
canonic11312933canoni_c
canonise10511093canonise
canonising1346583canonising
canonist10513533canonist
canonize1959833canonize
canonizing2247713canonizing
canons85522063cano__ns
canoodling1443583canoodling
canopic1338803canopi_c
canopied1336343canopied
canopies12311853canopies
canteen9411083canteen_
canteens1038573canteens
cantina93417253can_tina
canvasing1546433canvasing
canyonings1642873canyonings
capering132414963capering
capoeira1243353capoeira
capping143819673ca_pping
carding113922433ca_rding
careening12310013careening
careering12311203careering
caring95137993ca__ring
carking144322853ca_rking
carling103727063ca_rling
carolling1259413carolling
carotin92216733carotin_
carotins102315583carotins
carousing1237893carousing
carpeting1439483carpeting
carping123521083ca_rping
carroming1437683carroming
carrying14148373carrying
carting104228283ca_rting
cartoning12311113cartoning
carving133916773ca_rving
casein83216453ca_sein_
caseins93115053ca_seins
cashing135022553ca_shing
casing94829103ca__sing
casketing1635383casketing
casking144317353ca_sking
casting104628343ca_sting
castling11311233castling
catching163712773catching
catering112019903catering
catling104819793ca_tling
catting103922643ca_tting
caulking1536803caulking
causing103614413ca_using
caviling14310113caviling
caving124822613ca__ving
cavorting1536063cavorting
cawing124322613ca__wing
censing104215263cen_sing
censoring1238783censoring
centering122915143centering
centring112112953centring
chancing162810283chan_cing
changeling1745673changeling
changing153211513chan_ging
channeling1645203channeling
chanting143413533chan_ting
chasseing1554963chasseing
choking173911943c_hoking
choosing142010133choosing
choring133617663c_horing
chowing164412773c_howing
chroming163410723chroming
cinching163310223cinching
cindering13311223cindering
clamoring1477423clamoring
clanging124012123clan_ging
clangoring1443913clangoring
clanking154313063clan_king
cloning103215473c_loning
clonking153810153clonking
closing103114843c_losing
cloying133511753c_loying
clueing104110093c_lueing
coannexing2083163coannexing
coding104024793c__oding
coking134523883c__oking
coloring11414843coloring
coming114225453c__oming
conceding1559343conceding
condoling13510373condoling
condoning1339783condoning
congaing1239823congaing
congeeing1337903congeeing
coning94331823c__oning
conking143618453con_king
conning103718753con_ning
connoting12310023connoting
consoling12310873consoling
convening15311193convening
conveying1838323conveying
convoking1935743convoking
convoying1835983convoying
cooeeing1137453cooeeing
cooeying1438143c_ooeying
cooing94024923c__ooing
cooking143818973c_ooking
cooling103422573c_ooling
cooping123918933c_ooping
coping113927663c__oping
coring94433963c__oring
coting94629253c__oting
coving124321523c__oving
cowing124526323c__owing
coxing164218863c__oxing
coying124021483c__oying
cranching17278733cranching
craning103620303cran__ing
cranking154613073cran_king
crankling16147293crankling
crayoning1535243crayoning
crooking153611343crooking
crooning113112113crooning
crowing133814763c_rowing
cueing94913613c__ueing
cunning104214623cun_ning
cyaniding1644803cyaniding
dadoing1038523dado_ing
dancing113611563dan_cing
dandering122511063dandering
dandling112511733dandling
dangering12239303dangering
danging103716093dan_ging
dangling112611233dangling
denoting10311753denoting
eanling81416673ean_ling
fagoting1336283fagoting
fancying1735353fancying
fanning113615073fan_ning
favoring1596673favoring
gaeing84617223ga__eing
galoping1258023galoping
gandering122111293gandering
ganging103216193gan_ging
gangling112411403gangling
gaoling93314653ga_oling
garoting10510703garoting
haeing104118923ha__eing
haloing113814133halo_ing
handing123518893han_ding
handling132312713handling
hanging123518703han_ging
hankering17239383hankering
hanking154619103han_king
hanseling1338063hanseling
hanting114124483han_ting
hoeing104117023__hoeing
honoring12310473honoring
ignoring1036483ignoring
inbeing1038333_inbeing
jangling17249623jangling
kayoing1535403kayo_ing
kneeing12226523_kneeing
knowing15287683_knowing
laboring112110143laboring
lancing103314123lan_cing
landing92819323lan_ding
lanolin7310643lanolin_
lanoline8311953lanoline
lanolins8310533lanolins
longeing10177593longeing
majoring1836363majoring
managing1239093managing
mangling122312623mangling
manning103616383man_ning
mantling112012613mantling
manuring1139223manuring
masoning1139763masoning
minoring11311473minoring
nonbeing1137053nonbeing
nosing73419843__nosing
noting74120153__noting
pandering133211963pandering
pandying15217663pandying
paneling111013623paneling
panging113319113pan_ging
panning104019393pan_ning
panting104025423pan_ting
paroling113316213paroling
ranching141712043ranching
ranging94120263ran_ging
ranking124320883ran_king
rankling132610113rankling
ransoming1256513ransoming
ranting84025413ran_ting
razeeing1834363razeeing
razoring1836443razoring
sabeing102611863sa_being
sanding93520603san_ding
sandling102214413sandling
saning75127643san__ing
sauteing937913sauteing
savoring1269483savoring
scanning113310773scan_ning
scanting113914763scan_ting
scantling12107233scantling
shoeing113211883_shoeing
singeing10209933singeing
snoring83917203_snoring
snowing113913453_snowing
tabooing11186313tabooing
taboring113010193taboring
tanging93419523tan_ging
tangling101712543tangling
tangoing10177893tangoing
tanking123918793tan_king
tanning83618253tan_ning
tenoning938893tenoning
tingeing10198553tingeing
toeing74418473__toeing
unageing1036273unageing
unbeing1039373_unbeing
vamosing1435593vamosing
vanning113912463van_ning
vaporing1437653vaporing
venoming1436403venoming
wagoning1336923wagoning
wandering143310983wandering
wangling132310993wangling
waning103623803wan__ing
wanking154216783wan_king
wanning113816213wan_ning
wanting114220173wan_ting
wantoning1337083wantoning
yanking154512463yan_king

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623147.31319986.6
3Display Results3143140.1262492.1
 (SQL Overall)1786913147.84522777.7
 
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.