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

104 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
cancelled145674(None) 
canceled13279401cance_led
canceller1366681canceller
canalled1139582can_alled
canceler12238912cance_ler
cancellers1445362cancellers
cancered132411552cance_red
catcalled1444892catcalled
chandelled1744272chandelled
channelled1644142channelled
concealed1458132concealed
hanselled1345482hanselled
marcelled1445202marcelled
panelled1138962pan_elled
parcelled1445782parcelled
spancelled1543002spancelled
aneled74719283_an_e_led
angeled93211513_ange_led
annealed936343_annealed
annulled944843_annulled
anvilled1236483_anvilled
barrelled1245263barrelled
caballed1337163ca_balled
cackled164613303ca_c_kled
cadelle1039923ca_delle_
cadelles1139973ca_delles
called94126733ca___lled
canaille1048413canaille_
canailles1148273canailles
canaled103615563can__aled
canaller1038953can_aller
cancel105316683cance_l__
cancelable1644643cancelable_
cancelers13247863cancelers
canceling14310163canceling
cancelling1547213cancelling
cancellous1443643cancellous
cancels114113313cance_l_s
candled113815743can__dled
canella9310793can_ell_a
canellas10310563can_ellas
cankered153010223canke_red
canoodled1342803canoodled
cantered113415983cante_red
caracolled1543023caracolled
carolled1138833ca_rolled
catcaller1344813catcaller
cavilled1436733ca_villed
celled94420323___celled
chancellery2152273chancellery
chancellor1752913chancellor
chandelle1545223chandelle_
chandelles1645343chandelles
channeled1544913channe_led
chiselled1544223chiselled
compelled1646133compelled
concealer1368223concealer
conceded1438293conce_ded
conceited14310423conceited
conceived1746713conceived
concerned1438643concerned
concerted14312113concerted
congealed1346593congealed
corbelled1446613corbelled
cordelled1346403cordelled
counselled1344533counselled
crenelled1245403crenelled
cudgelled1443113cudgelled
cupelled1365743c_upelled
enamelled1244623enamelled
excelled18125703_excelled
flannelled1442843flannelled
funnelled1374233funnelled
gabelled12317583ga_belled
gavelled13387363ga_velled
handselled1543383handselled
hanseled1237713hanse_led
hatchelled1943013hatchelled
kennelled1443513kennelled
knelled12338993_kn_elled
labelled11278293la_belled
lancelet1049473lance_let
lanceted1137073lance_ted
lapelled11227083la_pelled
laurelled1043613laurelled
marceller1345153marceller
marvelled1544963marvelled
nacelle938153na_celle_
nacelles1048393na_celles
paneled10612573pan_e_led
parceled1338343parce_led
pencilled1445643pencilled
precancelled1951593precancelled
rappelled1443703rappelled
ravelled12419783ra_velled
sandalled1145903sandalled
scandalled1443073scandalled
snelled83313053_sn_elled
spanceled1443693spance_led
tasselled1044663tasselled
tinselled1044423tinselled
tunnelled1054583tunnelled
uncalled11810923_uncalled
uncanceled1543813uncance_led

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411046.73322076.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.20224811.3
 
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.