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

262 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
cartoon9411446(None) 
cardoon104813811cardoon
carton84522661cart_on
cartoons104012801cartoons
cartoony13377401cartoony
canton85722992cant_on
caption113513692caption
carbon104919042car_bon
cardon94120852car_don
cardoons113411942cardoons
caretook1445172caretook
carotin92216732carotin
carpool1139222carpool
carrion9312672carrion
carryon1237032carryon
cartons94122472cartons
cartooned1246312cartooned
cartop104213562cart_op
cation83925502ca_tion
caution93013522caution
craton84517192crat_on
croon75522782c_r_oon
croton84415452c_roton
harpoon1238312harpoon
jargoon1545192jargoon
lardoon83410372lardoon
maroon83118202mar_oon
parton84720992part_on
partook1337312partook
patroon92811972patroon
ratoon64417372ra_toon
rattoon7359242rattoon
aboon74918703_a_boon
action84719683_action
archon11311753_archon
argon65520593_ar_gon
arson55118833_ar_son
aswoon947013_aswoon
attorn6310793_attorn
baboon103613913ba_boon
balloon93711433balloon
baron78131243bar__on
barroom1139383barroom
barstool1044233barstool
baryon111211613bar_yon
baryton1246003baryton
bassoon937613bassoon
bastion9312473bastion
baton75822423ba_t_on
bradoon1037353bradoon
burton8311273burt_on
cabezon2044663cabezon
cactoid12311033cactoid
caftan111710123caft_an
cahoot11416473ca_hoot
caisson936593caisson
cajon144513903ca__jon
caldron1038153caldron
caltrop11267643caltrop
calutron1045553calutron
camion103917193ca_mion
campion133011413campion
cannon84514443ca_nnon
canon74725303ca__non
cantdog1134573cantdog
canteen9411083canteen
canto74931013cant_o_
cantons95221203cantons
cantor85621523cant_or
cantors94620753cantors
cantos84826973cant_os
canyon114512033ca_nyon
capon95221873ca__pon
captain112111063captain
captan101613343capt_an
captions123813223captions
captor104914603capt_or
captors113914983captors
carabin11313213carabin
caracol11310423caracol
caravan1239233caravan
carbarn1139453carbarn
carbo94923843car_bo_
carbons115418943carbons
carbora11310703carbora
carbos105122263car_bos
carboy134914183car_boy
carboys144711783carboys
cardamon1345553cardamon
cardio9915673cardio_
cardons104519943cardons
careen84119493car_een
careworn1347883careworn
cargo85322073car_go_
cargoes104415223cargoes
cargos94619183car_gos
carhop133610763car_hop
carhops14329703carhops
caribou1156993caribou
carillon1046963carillon
carioca1139683carioca
cariole9818343cariole
carious93320283carious
carlin84421823car_lin
carload1039783carload
carman103920743car_man
carmen104019343car_men
carn66245433car___n
carnation11312943carnation
carob95325223car__ob
carobs104818103car_obs
caroch13911763car_och
carol75128613car__ol
caroli85918233car_oli
carols85124983car_ols
carom95025563car__om
caroms105619573car_oms
carotene1039133carotene
carotid102014833carotid
carotins102315583carotins
carpools1237883carpools
carport11316033carport
carrions10312453carrions
carroch1437093carroch
carrom10513403car_rom
carroms11512403carroms
carrot8423123car_rot
carrotin102210893carrotin
carrots9714623carrots
carroty1248943carroty
carryons1337103carryons
cart66570343cart___
cartage10312593cartage
carte75940423cart__e
carted98631443cart_ed
cartel85022533cart_el
cartels94618123cartels
carter84932273cart_er
carters95327253carters
cartes86239473cart_es
carting104228283carting
cartload1145033cartload
cartoned111312833cartoned
cartoning12311113cartoning
cartooning1345883cartooning
cartoonish1563623cartoonish
cartoonist1257163cartoonist
cartouch15113513cartouch
carts78946293cart__s
carven114716663car_ven
caryotin13268353caryotin
cashoo11312253cashoo_
cashoos12310793cashoos
castoff1547793castoff
castor84418533cast_or
castors94919443castors
cations94524143ca_tions
catkin123512383ca_tkin
catlin83819083ca_tlin
cautions103313183cautions
certain92612213certain
chatroom1596263chatroom
chiton112612393chit_on
chronon1237353chronon
cistron9299883cistron
citron83112983c_itron
clarion9311663clar_ion
coaction12310773coaction
coatroom1276883coatroom
cocoon10312263c_ocoon
coition9314313coition
coon67248943c___oon
cordon95017293cor_don
cortin82423153cort_in
cotton8312993c_otton
crampon1336943crampon
crampoon1444543crampoon
cratons94316033cratons
crayon114110003c_rayon
crepon1039943c_repon
crook115217573c_r_ook
croons85418423c_r_oons
crotons93714373c_rotons
crown105620083c_r_own
curtain9319793curtain
cyton101511463c_yt_on
dahoon1039053da_hoon
dalton7311273dalt_on
dragoon935283dragoon
earthen1039253earthen
faction122613333faction
festoon1037673festoon
gaboon93211773ga_boon
gadroon938173gadroon
galloon82910643galloon
garcon92912483gar_con
garron73113493gar_ron
harpoons1337483harpoons
jargon1448823jar_gon
jargoons1644663jargoons
karoo92519583kar_oo_
karoos102415803kar_oos
karroo10410013karroo_
karroos1139313karroos
kation104315683ka_tion
kroon94514483_kr_oon
lagoon7410483la_goon
lampoon11267193lampoon
lardon74415063lar_don
lardoons9398483lardoons
macaroon1246343macar_oon
madzoon1996063madzoon
marathon1346823marathon
maroons92615553mar_oons
marron83717543mar_ron
martagon1145273martagon
marten84518263mart_en
martian93514683martian
martin84122523mart_in
mastodon1144383mastodon
matron83918313ma_tron
matzoon1896473matzoon
nation64322803na_tion
natron64116023na_tron
oration71617713oration
paction112713963paction
paragon10311023paragon
pardon94618733par_don
parson83817903par_son
partan83820563part_an
partons94620513partons
patron84018043pa_tron
patroons102710603patroons
picaroon1245653picar_oon
platoon938953platoon
pontoon93010703pontoon
portion9615493portion
proton84318893_proton
raccoon1176163raccoon
racoon83814473ra_coon
ration64226013ra_tion
ratoons73815473ra_toons
ratton64116123ra_tton
rattoons8327513rattoons
saloon64418023sa_loon
santoor737433santoor
sartor6313883sart_or
sartors7314973sartors
taction93213023taction
tardyon1134673tardyon
tarpon82812803tar_pon
tartan64217513tart_an
tattoo6310973tattoo_
tattoos738643tattoos
testoon748373testoon
toon47740633___toon
varoom11411413var_oom
waitron1036333waitron
wanton94413813want_on
warison1037083warison
warthog1444543warthog
warworn1357353warworn

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272627.03319056.9
3Display Results2622620.0902911.1
 (SQL Overall)1786912627.52923733.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.