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

183 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
cadelle103992(None) 
cadelles1139971cadelles
cadence1239062cadence
canella9310792canella
chandelle1545222chandelle
cordelle1148432cordelle
gabelle10259212gabelle
gazelle17236332gazelle
nacelle938152nacelle
abele76323253_abe_le
academe1244703acade_me
addle74318353_ad_dle
aedile73716653_aedile
allele64514563_allele
amarelle1045613amarelle
anele55628833_ane_le
areole61017283_areole
bedell93610043bedell_
bedells10379363bedells
belle75827833__belle
caballed1337163caballed
cable95329913ca__ble
cackle143416923ca_ckle
caddice13327733caddice
caddie104316453cad_die
cade76443913cad___e
cadenced1435523cadenced
cadences1338473cadences
cadency1545893cadency
cadent94120363cade_nt
cadenza1943773cadenza
cades85440733cade__s
cadet85339343cade__t
cadets96316513cade_ts
cadge94018793cad__ge
cadre85419023cad__re
cagelike1537723cagelike
cajole154011183ca_jole
caleche14297943caleche
calicle113111433calicle
call66838673ca__ll_
calla74827073ca__lla
called94126733ca__lled
callee84327293ca_llee
caller85125483ca__ller
callet84536763ca__llet
calls75634733ca__lls
calve105919923ca__lve
calycle14245833calycle
camel96822803came_l_
cameleer1246033cameleer
camelia11510433camelia
camelid1249413camelid
camellia1255443camellia
camellike1745063camellike
camels105217083came_ls
camerae11312063camerae
canaille1048413canaille
canalled1139583canalled
canaller1038953canaller
cancelled1456743cancelled
canceller1366683canceller
candela1089743cande_la
candelas1139533candelas
candle94321483ca_ndle
canellas10310563canellas
cantle84522153ca_ntle
canulae9311183canulae
capable13313363capable
capelan1139003capelan
capelet11517073capelet
capelin11510973capelin
capsule1137343capsule
caravelle1444703caravelle
cariole9818343cariole
carle74535703ca__rle
carolled1138833carolled
caroller1039203caroller
carpale113414353carpale
carrell94610473carrell_
carrells10359273carrells
casease939323casease
caseate9314783caseate
caseose939163caseose
caserne93710063caserne
casette9310393casette
castle84918963ca_stle
catenae9311373catenae
cattle85118903ca_ttle
caudally1446463caudally
caudillo1144483caudillo
caudle93912913ca_udle
cavalla1257883cavalla
cavally1588483cavally
cavelike1738213cavelike
cavilled1436733cavilled
caviller1337063caviller
cayenne1244603cayenne
cedilla1036343cedilla
cell65031723c__ell_
cella75420313c__ella
cellae84915933c__ellae
celled94420323c__elled
celli76717693c__elli
cello74919583c__ello
cells75428063c__ells
chandelled1744273chandelled
chandelles1645343chandelles
chelae113614603c_helae
cineole91010003cineole
codable12311663codable
coddle104713853cod_dle
codeine103815033codeine
cordelled1346403cordelled
cordelles1248233cordelles
cradle93313163crad__le
crenelle1046333crenelle
creole8913733c_reole
crueller1056453crueller
cruelly1236563cruelly
cubanelle1372483cubanelle
cuddle104414533cud_dle
cudgelled1443113cudgelled
cupelled1365743cupelled
cupeller1256103cupeller
daddle94214283dad_dle
dele56843083__de_le
dell56938203__dell_
dells66630943__dells
delly96023873__delly
delve96018263__delve
echelle1246623echelle
fadable13310463fadable
fadedly1535453fadedly
faille93414743fa_ille
favella1336173favella
gabelled12317583gabelled
gabelles11278933gabelles
gavelled13387363gavelled
gazelles18266563gazelles
hazelly2254383hazelly
jadedly1934013jadedly
jadeite1546403jadeite
jadelike2035993jadelike
labella988943labella
labelled11278293labelled
labeller10248073labeller
ladle66320443lad__le
lamella988613lamella
lamellae10117033lamellae
lapelled11227083lapelled
manille92613273manille
micelle1178343micelle
modelled1236433modelled
modeller1136613modeller
morelle91210803morelle
nacelles1048393nacelles
novelle1058233novelle
paddle104615143pad_dle
padle84522343pad__le
paella8410913pa_ella
panelled1138963panelled
patella938953patella
patellae1047623patellae
raddle84816173rad_dle
radiale83813523radiale
radicle103510713radicle
radulae837963radulae
ravelled12419783ravelled
raveller11339263raveller
ravelly13268353ravelly
rondelle946813rondelle
roselle7310243roselle
saddle83915493sad_dle
selle54428313__selle
spadille1145193spadille
tadpole1036143tadpole
taille63116923ta_ille
wadable13310233wadable
waddle114715303wad_dle
wadeable1437443wadeable
yodelled1334603yodelled
yodeller1244853yodeller

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271836.01322289.5
3Display Results1831830.0802287.5
 (SQL Overall)1786911836.49927495.2
 
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.