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

259 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
cartoned11131283(None) 
cantoned111411521cantoned
cartooned1246311cartooned
atoned75417542_a_toned
caftaned1445092caftaned
cannoned11118132cannoned
captioned1445762captioned
carboyed1637182carboyed
careened1139192careened
caroled103717682car_oled
caromed123713622car_omed
carromed1338562carromed
carted98631442cart__ed
carton84522662carton__
cartons94122472carton_s
cautioned1245362cautioned
clarioned1245722clarioned
cordoned12229612cordoned
cottoned1138032cottoned
crayoned1435002crayoned
crooned103813342c_rooned
jargoned1735232jargoned
marooned1138562marooned
pardoned12189332pardoned
wantoned12117222wantoned
acetone9310793acetone_
acetones10310033acetones
aproned10311503_aproned
arbored103811603_arbored
armored102610473_armored
arrowed1148103_arrowed
astonied978983_astonied
atone56527983_a_tone_
atoner64817193_a_toner
atones65225773_a_tones
attorned955353_attorned
attuned835173_attuned
autoed7712823_auto_ed
bareboned1445103bareboned
baritone1058643baritone_
baritones1158943baritones
barned95623583bar__ned
baronet91022203bar_onet
bartend1038753barten_d
bartended1344663bartended
bartered113113013bartered
barytone1356023barytone_
barytones1455563barytones
bastioned1246863bastioned
battened11259573battened
buttoned1137503buttoned
cabined1239993ca_bined
cactoid12311023cacto_id
cairned1037643ca_irned
cajoled17428273ca_joled
cajones163311333ca_jones
calcined1338743calcined
calzone1848623calzone_
calzones1948763calzones
cameoed1238383cameo_ed
caned85838093ca___ned
canned95022063ca__nned
canoed94618953ca_no_ed
canted94825783cant__ed
cantered113415983cantered
canton85722993canton__
cantonal1038903cantonal
cantons95221203canton_s
canzone1858813canzone_
canzones1939153canzones
canzonet19410583canzonet
caprioled1464743caprioled
capstone1237653capstone_
capstones1347373capstones
captained1446193captained
captured1336563captured
caracoled1445983caracoled
caravaned1544983caravaned
carbine112918643carbine_
carbines123617533carbines
carbon104919043carbon__
carbonade1446543carbonade
carbonado1444383carbonado
carbonated1547243carbonated
carbonic1439993carbonic
carbonized24157053carbonized
carbons115418943carbon_s
carbonyl1595383carbonyl
carcanet12316343carcanet
carded105424903car__ded
cardon94120853cardon__
cardons104519933cardon_s
cared86050093car___ed
careener1039323careener
careered1139493careered
caressed1139163caressed
cargoes104415223cargo_es
carhopped1972763carhopped
caried94528693car__ied
cariole9818343cariole_
carioles10817063carioles
carked134024823car__ked
carline93923613carline_
carlines103521643carlines
carload1039783carlo_ad
carmine112918483carmine_
carmines123617863carmines
carnet84732873car__net
carney115315703car__ney
caroler93816753car_oler
carolled1138823carolled
carotene1039133carotene
carotenes11410203carotenes
carotid102014813car_otid
caroused1149253caroused
carped115923763car__ped
carpeted1338943carpeted
carpooled1445063carpooled
carried103717153car_ried
carronade1246093carronade
cartage10312593cartage_
cartages11313313cartages
carte75940423cart__e_
cartel85022533cart__el
carter84932273cart__er
cartes86239473cart__es
carting104228283cartin_g
cartload1145033cartload
cartoning12311113cartoning
cartoon94114463carto_on
cartoons104012803cartoons
cartoony13377403cartoony
cartop104213563carto__p
cartopper1543733cartopper
cartouch15113493cartouch
carved124320853car__ved
castanet10416193castanet
castled104311513cast_led
catered103117763ca_tered
catted95422473ca_t_ted
cautioner1145393cautioner
caverned1436163caverned
cayenned1443163cayenned
centones10313663centones
charioted1595863charioted
charted135116853chart__ed
chartered15158383chartered
chastened1545883chastened
chromed153510923chr_omed
clarionet1149833clarionet
cloned94518803c__loned
coarsened1245143coarsened
cocooned1337293cocooned
condoned122612023condoned
coned86040053c___oned
corned95224523cor__ned
coronel94515223cor_onel
coroner94218203cor_oner
coronet94227173cor_onet
corroded12147513corroded
craned96121653c_r_aned
crated94827773crat__ed
cratered1149673cratered
craton84517193craton__
cratonic1239113cratonic
cratons94316033craton_s
cravened1476713cravened
crayoner1344853crayoner
crone75231333c_r_one_
crones84729243c_r_ones
crooked143910943c_rooked
crooner93714043c_rooner
crowed124717293c_r_owed
crowned133912423c_rowned
curtained1265503curtained
curtsied1134953curtsied
darkened1435943darkened
darned85018483dar__ned
darted84620923dart__ed
dartled9409853dart_led
droned84616863_dr_oned
earned74818333ear__ned
earstone848593earstone_
earstones948523earstones
earthed1139923eart_hed
factored1436213factored
farrowed1545283farrowed
farted105121783fart__ed
fastened12257853fastened
fattened12268283fattened
fortuned1285323fortuned
gadrooned1243403gadrooned
gammoned1444993gammoned
gardened1137003gardened
garoted9710133gar_oted
garotted1066193garotted
garroted1056783garroted
gartered10319583gartered
hamboned1637003hamboned
harbored1438633harbored
hardened1338613hardened
harkened1637483harkened
harpooned1544323harpooned
harrowed1556263harrowed
hastened12239103hastened
heartened1347063heartened
intoned8811983_intoned
ironed74916013_ir_oned
jargonel1643683jargonel
jawboned21133553jawboned
lactone9311393lactone_
lactones10311223lactones
latened8711923la_tened
margined1237743margined
marrowed1445973marrowed
marted94425213mart__ed
martinet10319643martinet
martyred1434283martyred
masoned1039803ma_soned
narrowed1235203narrowed
paragoned1357063paragoned
pardoner11189443pardoner
paroled104217613par_oled
parroted1158843parroted
parted94228683part__ed
partied103516553part_ied
partner92811393part_ner
parton84720993parton__
partons94620513parton_s
pastored1139963pastored
patined105114783pa_tined
pattened11299393pattened
picarooned1552353picarooned
portioned1248333portioned
rationed9410093rationed
ratooned977103ratooned
rattened9218623rattened
rattooned1043843rattooned
rawboned14114253rawboned
sardined10268663sardined
scarted104816123scart__ed
smartened1244263smartened
stoned75923143__stoned
taloned8310223ta_loned
tamponed1336023tamponed
tarted74923373tart__ed
tattooed944573tattooed
tautened935423tautened
throned115412173thr_oned
toned65435343___toned
unatoned939423unatoned
unstoned9311043unstoned
varoomed1445293varoomed
waggoned1443253waggoned
wagoned1256223wa_goned
wantoner1187553wantoner
warned104018913war__ned
warted104223233wart__ed
yarned105514023yar__ned

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.1561145455.1
2DLD Change Limit1461622598.01618233.8
3Display Results2592590.1102354.5
 (SQL Overall)1786912598.28221575.8
 
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.