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

162 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
cantoning1231088(None) 
cannoning1237321cannoning
canyoning1536871canyoning
cartoning12311111cartoning
wantoning1337081wantoning
atoning83514872_a_toning
canning103620132can__ning
canoeing11310212can_oeing
cantering122417372cantering
canting104725902cant__ing
canyonings1642872canyonings
captioning1545692captioning
cartooning1345882cartooning
cautioning1345712cautioning
condoning1339782condoning
cottoning1237342cottoning
intoning9311122_intoning
santonin849692santonin_
santonins948452santonins
abandoning1472583abandoning
annoying1246543_annoying
anteing8312813_ant_eing
antiking13412063_antiking
anting75827023_ant__ing
aproning11311793_aproning
astonying1345233_astonying
attorning1045503_attorning
attuning935903_attuning
autoing8314043_auto_ing
banning103818233ban__ning
bantering122414233bantering
bantling112611993bant_ling
battening12268853battening
buttoning1246463buttoning
cabining1338643ca_bining
cajoling18318423ca_joling
calcining1447813calcining
cameoing1379063cameo_ing
canaling112016403can_aling
canalling1239543canalling
canceling14310163canceling
candling122313873can_dling
candying15188993can_dying
caning94128623ca___ning
cankering162110793cankering
cannings113710333can__nings
cannonading1552383cannonading
canonic11312933can_oni_c
canonise10511093can_onise
canonising1346573can_onising
canonist10513533can_onist
canonize1959833can_onize
canonizing2247703can_onizing
canoodling1443583canoodling
canopying1745063canopying
cantina93417253cant__ina
canton85722993canto__n_
cantonal1038903canton_al
cantoned111411523canton_ed
cantonment1445973cantonment
cantons95221203canto__ns
cantorial1149793cantorial
canvasing1546433canvasing
canzoni1836153canzoni__
captaining1546063captaining
capturing1436613capturing
careening12310013careening
caroling113317003ca_roling
caroming133312963ca_roming
carroming1437673carroming
carting104228283cart__ing
cartoonings1442663cartoonings
casting104628343cast__ing
castling11311233cast_ling
catching163712773ca_tching
catering112019903ca_tering
catling104819793ca_t_ling
catting103922643ca_t_ting
caverning1536283caverning
censoring1238783censoring
centering122915143centering
centring112112953cent_ring
chanting143413533chant__ing
chastening1656523chastening
clangoring1443913clangoring
clarioning1345183clarioning
cloning103215473c__loning
cocooning1447023cocooning
condoling13510373condoling
confining1539993confining
coning94331823c___oning
conjoining2046103conjoining
conning103718753con__ning
connoting12310023connoting
consoling12310873consoling
containing13410923containing
contemning1577063contemning
contending1449123contending
contenting13313323contenting
continuing1348193continuing
contorting13410103contorting
contouring1347003contouring
contusing1239143contusing
convening15311193convening
convoking1935743convoking
convoying1835983convoying
cordoning1338063cordoning
couponing1446283couponing
crayoning1535243crayoning
crooning113112113c_rooning
cunning104214623cun__ning
factoring1537523factoring
fanning113615073fan__ning
fastening13268603fastening
fattening13287833fattening
gammoning1545063gammoning
hamboning1745893hamboning
hanting114124483hant__ing
hastening13259483hastening
jargoning1845983jargoning
jawboning22133413jawboning
landowning1543153landowning
latening9711493la_tening
manning103616383man__ning
mantling112012603mant_ling
marooning1238593marooning
masoning1139763ma_soning
mentioning1345793mentioning
mentoring1239543mentoring
nooning83014853__nooning
panning104019393pan__ning
panting104025423pant__ing
pardoning1338763pardoning
pastoring12310843pastoring
patining11312303pa_tining
pinioning1246863pinioning
ransoming1256503ransoming
ranting84025413rant__ing
rationing1039783rationing
ratooning1037173ratooning
rattening10288763rattening
rattooning1143953rattooning
sanctioning1453993sanctioning
santolina946263santolina
santonica1145373santonica
scanning113310773scan__ning
scanting113914763scant__ing
scantling12107233scant_ling
stoning83717443__stoning
tamponing1445993tamponing
tangoing10177893tango_ing
tanning83618253tan__ning
tattooing1043963tattooing
tautening1035843tautening
tenoning938893ten_oning
toning74025793___toning
untuning937943_untuning
vanning113912463van__ning
waggoning1543593waggoning
wagoning1336923wa_goning
wanning113816213wan__ning
wanting114220173want__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.1731032896.0
2DLD Change Limit1486411627.26320465.5
3Display Results1621620.0802025.0
 (SQL Overall)1786911627.51623774.7
 
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.