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

193 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
cardoons11341194(None) 
cardons104519941card_ons
cardoon104813811cardoon_
cartoons104012801cartoons
lardoons9398481lardoons
bradoons1136762bradoons
caldrons1138062caldrons
carbons115418942car_bons
cardamons1445202cardamons
cardon94120852card_on_
carpools1237882carpools
carrions10312452carrions
carryons1337102carryons
cartons94122472car_tons
cartoon94114462cartoon_
cartoony13377402cartoony
cordons104415762cord_ons
croons85418422c_r_oons
gadroons1037012gadroons
harpoons1337482harpoons
jargoons1644662jargoons
lardons83914492lard_ons
lardoon83410372lardoon_
maroons92615552mar_oons
pardons103817622pard_ons
tardyons1244612tardyons
acrodont1148123acrodont
acrodonts1244523acrodonts
adorns74212613_a_dorns
archons12311583_archons
ardors74416873_ard_ors
ardours8368883_ardours
arduous837613_arduous
argons75018203_ar_gons
arsons63917213_ar_sons
baboons113211083ba_boons
balloons103110523balloons
barons85025383bar__ons
barrooms1237893barrooms
baryons121010473bar_yons
barytons1345573barytons
bassoons1036553bassoons
baudrons1135763baudrons
bradoon1037353bradoon_
bridoons1145423bridoons
cabezons2144553cabezons
cahoots1238473ca_hoots
caissons1036283caissons
caldron1038153caldron_
camions113916133ca_mions
campions143511293campions
candors104216763cand_ors
candours11408643candours
cannons94412883ca_nnons
canons85522063ca__nons
cantons95221203ca_ntons
canyons124511593ca_nyons
capons104119503ca__pons
captions123813223captions
carabins12312363carabins
caracols12310413caracols
caravans1338623caravans
carbarns1238563carbarns
carbon104919043car_bon_
carbonous1347063carbonous
carboras12311583carboras
carbos105122263car_bo_s
carboys144711783car_boys
cardamoms1643513cardamoms
cardamon1345553cardamon_
carders104820353card_ers
cardiacs1376923cardiacs
cardias10715123card_ias
cardigans1345163cardigans
carding113922443card_ing
cardings123812643cardings
cardio9915673cardio__
cardioid1247453cardioid
cardioids1345233cardioids
carditis11310233carditis
cards85137933card___s
careens94514703car_eens
cargoes104415223car_goes
cargos94619183car_go_s
carhops14329703car_hops
caribous1258823caribous
carillons1146363carillons
cariocas1239663cariocas
carioles10817073carioles
carious93320283car_ious
carlins93921923car_lins
carloads1138393carloads
carns75937563car___ns
carobs104818103car__obs
carols85124983car__ols
carolus94612603car_olus
caroms105619573car__oms
carotins102315583carotins
carpool1139223carpoo_l
carports1238943carports
carrion9312673carrion_
carroms11512403car_roms
carrotins11239963carrotins
carrots9714623car_rots
carryon1237033carryon_
carton84522663car_ton_
cartooned1246313cartooned
cartoonish1563623cartoonish
cartoonist1257163cartoonist
caryotins14248043caryotins
cashoos12310793cashoo_s
cations94524143ca_tions
cauldrons1242973cauldrons
cautions103313183cautions
chaldrons1545493chaldrons
chronons1347353chronons
clarions10310493clar_ions
cocoons11310563c_ocoons
codons96119463c_od_ons
coons76737283c___oons
cordobas1345803cordobas
cordon95017293cord_on_
cordovans1543683cordovans
cordwoods16104773cordwoods
crampons1436643crampons
crampoons1544063crampoons
cratons94316033c_ratons
crayons12439233c_rayons
crepons1139323c_repons
crooks124914413c_r_ooks
croon75522783c_r_oon_
crotons93714373c_rotons
crowns115615113c_r_owns
cutdowns1443343cutdowns
czardoms2243743czard_oms
dahoons1137753da_hoons
dragoons1045013dragoons
eardrops1165303eardrops
gaboons10289903ga_boons
gadroon938173gadroon_
galloons9289703galloons
garcons102411643gar_cons
gardens93312093gard_ens
garrons82713463gar_rons
godroons1045363godroons
hadrons113314303ha_drons
hagdons1258523hagd_ons
hardboots1544353hardboots
hardens113815023hard_ens
hardgoods15153653hardgoods
hardpans1436453hardpans
hardtops1444843hardtops
hardwoods17135513hardwoods
harpoon1238313harpoon_
jargons1558203jar_gons
jargoon1545193jargoon_
karoos102415803kar_oo_s
karroos1139313karroo_s
kroons103711243_kr_oons
ladrons83813193la_drons
lagoons839253la_goons
lampoons12266873lampoons
lardon74415063lard_on_
macaroons1345563macar_oons
madronos11337543madronos
madzoons20124773madzoons
markdowns1942463markdowns
maroon83118203mar_oon_
marrons93216973mar_rons
matzoons19105083matzoons
pandoors11258983pandoors
paragons11311503paragons
pardon94618733pard_on_
parodos103011753parodo_s
parsons93516873par_sons
partons94620513par_tons
patroons102710603patroons
picaroons1344673picar_oons
quadroons1944183quadroons
raccoons1265453raccoons
racoons93912433ra_coons
radons74118533ra_d_ons
ratoons73815473ra_toons
rattoons8327513rattoons
saloons74415323sa_loons
tandoors9258053tandoors
tardyon1134673tardyon_
tarpons92612213tar_pons
teardowns1343043teardowns
varooms1248883var_ooms
wardens113711903ward_ens
wardrooms1544183wardrooms
warisons1136903warisons

Search took 9 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.403443402.0
2DLD Change Limit1461621937.92318447.8
3Display Results1931930.0802412.5
 (SQL Overall)1786911938.40621257.6
 
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.