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

110 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
cantonal103890(None) 
anconal939422_anconal
atonal6514022_a_tonal
cantal84122032cant__al
canthal12410052cant_hal
cantina93417252cantina_
cantinas102713772cantinas
canton85722992canton__
cantoned111411522cantoned
cantons95221202canton_s
cantorial1149812cantorial
canzona1836072canzona_
canzonas1935382canzonas
nontonal849742nontonal
actinal9312293_actinal
agonal7410053_a_gonal
ammonal1137023_ammonal
anconeal1045593_anconeal
anginal8310163_anginal
annal56520763_an__nal
annona648873_annona_
annonas738793_annonas
anodal72512123_an_odal
antennal856353_antennal
antonym1246513_antonym
antral65719413_ant_ral
axonal1347653_a_xonal
azonal1568273_a_zonal
baritonal1144673baritonal
canal75428043ca___nal
candidal12367733candidal
canna75919333can__na_
cannas84518403can__nas
cannel84216403can__nel
cannibal1245203cannibal
cannon84514443cannon__
cannonade12123953cannonade
cannonball1451713cannonball
cannoned11118143cannoned
cannonry1343293cannonry
cannons94412883cannon_s
canola8313623can_ola_
canolas9313993can_olas
canon74725303can_on__
canonic11312933can_onic
canonical1347213can_onical
canonry1235923can_onry
canons85522063can_on_s
cantala94114673cant__ala
cantalas104013523cantalas
cantals93919573cant__als
cantata93811813cantata_
cantatas103410093cantatas
canting104725903cantin_g
canto74931013canto___
cantoning12310883cantoning
cantor85621523canto__r
cantors94620753canto_rs
cantos84826973canto__s
cantrap113310283cant_rap
canyon114512033canyon__
canyons124511593canyon_s
canzone1858813canzon_e
canzones1939153canzones
canzonet19410583canzonet
canzoni1836153canzon_i
caporal11410943ca_poral
carbonyl1595383carbonyl
cardinal1139563cardinal
carinal94318233ca_rinal
carnal83919203ca__rnal
carton84522663carton__
cartoned111312833cartoned
cartons94122473carton_s
catena8312483ca_tena_
catenae9311373ca_tenae
catenas9313113ca_tenas
cathodal14155413cathodal
catnap1098383ca_t_nap
cental84420963cent__al
centones10313663centones
central93114473cent_ral
clitoral10106463clitoral
clonal8310913c__lonal
coitional1148693coitional
confocal1546303confocal
continual1147143continual
coronal94115763c_oronal
cyclonal1544603cyclonal
dentinal939503dentinal
ecotonal1046253ecotonal
factional1478763factional
lagoonal943093lagoonal
lantana739603lantana_
lantanas838263lantanas
mangonel1185763mangonel
matinal9312603ma_tinal
matronal1048113matronal
national8311533national
pastoral10310483pastoral
patronal1048653patronal
rational8412543rational
santol64515243santo__l
santonin849703santonin
tonal53724303___tonal
wanton94413813wanton__
wantoned12117223wantoned
wantoner1187563wantoner
wantonly1443063wantonly
wantons103713013wanton_s

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.406440125.6
2DLD Change Limit1461621107.90618487.5
3Display Results1101100.0303666.7
 (SQL Overall)1786911108.34221420.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.