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

232 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
cartoons10401280(None) 
cardoons113411941cardoons
cartons94122471cart_ons
cartoon94114461cartoon_
cartoony13377401cartoony
cantons95221202cant_ons
captions123813222captions
carbons115418942car_bons
cardons104519932car_dons
cardoon104813812cardoon_
carotins102315582carotins
carpools1237882carpools
carrions10312452carrions
carryons1337102carryons
carton84522662cart_on_
cartooned1246312cartooned
cartoonish1563622cartoonish
cartoonist1257162cartoonist
cations94524142ca_tions
cautions103313172cautions
cratons94316032crat_ons
croons85418422c_r_oons
crotons93714372c_rotons
harpoons1337472harpoons
jargoons1644662jargoons
lardoons9398482lardoons
maroons92615552mar_oons
partons94620512part_ons
patroons102710602patroons
ratoons73815472ra_toons
rattoons8327512rattoons
actions94218513_actions
archons12311583_archons
argons75018203_ar_gons
arsons63917213_ar_sons
attorns738433_attorns
baboons113211073ba_boons
balloons103110503balloons
barons85025383bar__ons
barrooms1237893barrooms
barstools1143543barstools
baryons121010473bar_yons
barytons1345573barytons
bassoons1036543bassoons
bastions10411693bastions
batons85519423ba_t_ons
bradoons1136753bradoons
burtons9310853burt_ons
cabezons2144543cabezons
caftans12179443caft_ans
cahoots1238473ca_hoots
caissons1036283caissons
caldrons1138063caldrons
caltrops12307863caltrops
calutrons1145483calutrons
camions113916133ca_mions
campions143511293campions
cannons94412883ca_nnons
canons85522063ca__nons
cantdogs1244043cantdogs
canteens1038573canteens
canton85722993cant_on_
cantors94620753cant_ors
cantos84826973cant_o_s
canyons124511593ca_nyons
capons104119503ca__pons
captains121810573captains
captans111612053capt_ans
caption113513693caption_
captious122810563captious
captors113914983capt_ors
carabins12312353carabins
caracols12310413caracols
caravans1338613caravans
carbarns1238563carbarns
carbon104919043car_bon_
carbonous1347063carbonous
carboras12311573carboras
carbos105122263car_bo_s
carboys144711783car_boys
cardamons1445203cardamons
cardon94120853car_don_
careens94514703car_eens
caretook1445173caretoo_k
cargoes104415223car_goes
cargos94619183car_go_s
carhops14329703car_hops
caribous1258823caribous
carillons1146353carillons
cariocas1239663cariocas
carioles10817073carioles
carious93320283car_ious
carlins93921913car_lins
carloads1138393carloads
carnations12311353carnations
carns75937563car___ns
carobs104818103car__obs
carols85124983car__ols
carolus94612603car_olus
caroms105619573car__oms
carotene1039133carotene
carotenes11410203carotenes
carotids11229933carotids
carotin92216713carotin_
carpool1139223carpoo_l
carports1238943carports
carrion9312673carrion_
carroms11512403car_roms
carrotins11239963carrotins
carrots9714623car_rots
carryon1237033carryon_
cartages11313313cartages
cartels94618123cart_els
carters95327243cart_ers
cartes86239473cart__es
carthorse1446293carthorse
carting104228283cart_ing
cartload1145033cartload
cartloads1244523cartloads
cartoned111312833cartoned
cartoning12311113cartoning
cartooning1345883cartooning
cartoonings1442663cartoonings
cartoonists1384403cartoonists
cartop104213563cart_o_p
cartouch15113493cartouch
carts78946293cart___s
caryotins14248043caryotins
cashoos12310793cashoo_s
castoffs1644043castoffs
castors94919433cast_ors
cation83925503ca_tion_
catkins133012563ca_tkins
catlins93818843ca_tlins
caution93013513caution_
cautious103110223cautious
chatrooms1685103chatrooms
chitons122611913chit_ons
chronons1347353chronons
cistrons102710623cistrons
citrons92913223c_itrons
clarions10310493clar_ions
coactions1349743coactions
coatrooms1385413coatrooms
cocoons11310563c_ocoons
coitions10312853coitions
coons76737283c___oons
cordons104415763cor_dons
cortins92421323cort_ins
cottons9312193c_ottons
crampons1436643crampons
crampoons1544063crampoons
craton84517193crat_on_
crayons12439233c_rayons
crepons1139313c_repons
crooks124914413c_r_ooks
croon75522783c_r_oon_
croton84415453c_roton_
crowns115615113c_r_owns
curtains10259703curtains
cytons111710183c_yt_ons
dahoons1137753da_hoons
daltons8310403dalt_ons
dragoons1045013dragoons
factions133013063factions
festoons1136433festoons
gaboons10289893ga_boons
gadroons1037013gadroons
galloons9289683galloons
garcons102411643gar_cons
garrons82713463gar_rons
harpoon1238313harpoon_
jargons1558203jar_gons
jargoon1545193jargoon_
karoos102415803kar_oo_s
karroos1139313karroo_s
kations114013663ka_tions
kroons103711243_kr_oons
lagoons839253la_goons
lampoons12266863lampoons
lardons83914493lar_dons
lardoon83410373lardoon_
macaroons1345563macar_oons
madzoons20124773madzoons
marathons1446413marathons
maroon83118203mar_oon_
marrons93216973mar_rons
martagons1245123martagons
martens93714953mart_ens
martians103111613martians
martins93322063mart_ins
mastodons1244123mastodons
matrons93517633ma_trons
matzoons19105083matzoons
nations74720563na_tions
natrons73215663na_trons
orations81515803orations
pactions122613503pactions
paragons11311503paragons
pardons103817623par_dons
parsons93516873par_sons
partans94418283part_ans
parton84720993part_on_
partook1337313partoo_k
patrons93818103pa_trons
patroon92811973patroon_
picaroons1344673picar_oons
platoons1038683platoons
pontoons10279313pontoons
portions10514403portions
protons93118003_protons
raccoons1265453raccoons
racoons93912433ra_coons
rations74123433ra_tions
ratoon64417373ra_toon_
rattons73815323ra_ttons
rattoon7359243rattoon_
saloons74415303sa_loons
santoors837633santoors
sartors7314953sart_ors
tactions102912423tactions
tardyons1244613tardyons
tarpons92612203tar_pons
tartans72615823tart_ans
tattoos738643tattoo_s
testoons837303testoons
toons55027533___toons
varooms1248883var_ooms
waitrons1136633waitrons
wantons103713013want_ons
warisons1136903warisons
warthogs1544823warthogs

Search took 10 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.1561145455.1
2DLD Change Limit1461622329.20315882.0
3Display Results2322320.0932494.6
 (SQL Overall)1786912329.45218905.1
 
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.