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

187 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
cartoning1231111(None) 
cantoning12310881cantoning
cartooning1345881cartooning
atoning83514872_a_toning
cannoning1237322cannoning
canyoning1536872canyoning
captioning1545702captioning
careening12310012careening
caroling113317002car_oling
caroming133312962car_oming
carroming1437682carroming
carting104228282cart__ing
cartoonings1442662cartoonings
cautioning1345722cautioning
clarioning1345182clarioning
cordoning1338062cordoning
cottoning1237342cottoning
crayoning1535242crayoning
crooning113112112c_rooning
jargoning1845982jargoning
marooning1238592marooning
pardoning1338762pardoning
wantoning1337082wantoning
aproning11311793_aproning
armoring1149123_armoring
arrowing1237943_arrowing
astonying1345233_astonying
attorning1045503_attorning
attuning935903_attuning
autoing8314043_auto_ing
barning104320353bar__ning
bartending1444913bartending
bartering122313643bartering
battening12268853battening
buttoning1246463buttoning
cabining1338643ca_bining
cajoling18318423ca_joling
calcining1447813calcining
cameoing1379063cameo_ing
caning94128623ca___ning
canning103620133ca__nning
canoeing11310213ca_noeing
cantering122417373cantering
canting104725903cant__ing
canyonings1642873canyonings
caprioling1544523caprioling
captaining1546073captaining
capturing1436623capturing
caracoling1545633caracoling
caravaning1644423caravaning
carbonating1645853carbonating
carbonic1439993carboni_c
carbonium1546613carbonium
carbonize22169043carbonize
carbonizing2545863carbonizing
carding113922433car__ding
careering12311203careering
caressing1238803caressing
caretaking1765333caretaking
carhopping2042993carhopping
caring95137993car___ing
carking144322853car__king
carling103727063car__ling
carolling1259413carolling
carotin92216733car_otin_
carotins102315583car_otins
carousing1237893carousing
carpeting1439483carpeting
carping123521083car__ping
carpooling1545023carpooling
carrotin102210893carrotin_
carrotins11239963carrotins
carrying14148373car_rying
carton84522663carto__n_
cartoned111312833carton_ed
cartons94122473carto__ns
cartoon94114463carto_on_
cartoonish1563623cartoonish
cartoonist1257163cartoonist
cartoons104012803carto_ons
cartoony13377403carto_ony
carving133916773car__ving
caryotin13268353caryotin_
caryotins14248043caryotins
casting104628343cast__ing
castling11311233cast_ling
catching163712773ca_tching
catering112019903ca_tering
catling104819793ca_t_ling
catting103922643ca_t_ting
caverning1536283caverning
charioting1645723charioting
chartering16109253chartering
charting142614193chart__ing
chastening1656523chastening
chroming163410723chr_oming
cloning103215473c__loning
coarsening1345543coarsening
cocooning1447023cocooning
condoning1339783condoning
coning94331823c___oning
corning103720123cor__ning
corroding1337943corroding
couponing1446293couponing
craning103620303c_r_aning
cratering12312653cratering
crating103725203crat__ing
cratonic1239113cratoni_c
cravening1547553cravening
crooking153611343c_rooking
crowing133814763c_r_owing
crowning143510033c_rowning
curtaining1345533curtaining
curtsying1543813curtsying
darkening1535683darkening
darning93817333dar__ning
darting94020663dart__ing
dartling1039563dart_ling
droning93013723_dr_oning
earning83418213ear__ning
earthing12310323eart_hing
earthling1346193earthling
factoring1537523factoring
farrowing1645873farrowing
farthing1538073fart_hing
farting114120753fart__ing
fastening13268603fastening
fattening13287833fattening
fortuning1345493fortuning
gadrooning1343543gadrooning
gammoning1545063gammoning
gardening1236513gardening
garoting10510703gar_oting
garotting1136103garotting
garroting1136953garroting
gartering112111573gartering
hamboning1745893hamboning
harboring1538263harboring
hardening1438023hardening
harkening1746923harkening
harpooning1644483harpooning
harrowing1646433harrowing
hastening13259483hastening
heartening1446733heartening
intoning9311123_intoning
ironing82414013_ir_oning
jawboning22133413jawboning
karting123716063kart__ing
latening9711493la_tening
marathoning1752823marathoning
margining1337603margining
marrowing1546663marrowing
marting103325013mart__ing
martyring1535783martyring
masoning1139763ma_soning
narrowing1345603narrowing
paragoning1445953paragoning
paroling113316213par_oling
parroting1239153parroting
partaking1698673partaking
parting103527383part__ing
partying14168893part_ying
pastoring12310853pastoring
patining11312303pa_tining
picarooning1652433picarooning
portioning1347193portioning
rationing1039783rationing
ratooning1037173ratooning
rattening10288763rattening
rattooning1143953rattooning
santonin849703santonin_
santonins948453santonins
sardining1137573sardining
scarting113415263scart__ing
smartening1344993smartening
stoning83717443__stoning
tamponing1445993tamponing
tarting84222653tart__ing
tattooing1043963tattooing
tautening1035843tautening
throning1238863thr_oning
toning74025793___toning
varooming1545083varooming
waggoning1543593waggoning
wagoning1336923wa_goning
warning113717093war__ning
yarning113512953yar__ning

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.1561145455.1
2DLD Change Limit1486411877.00021234.4
3Display Results1871870.0762460.5
 (SQL Overall)1786911877.23224708.4
 
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.