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

152 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
cadence123906(None) 
cadenced1435521cadenced
cadences1338471cadences
cadency1545891cadency
caddice13327732caddice
cadelle1039922cadelle
cadencies1447322cadencies
cadent94120362caden_t
cadenza1943772cadenza
catenae9311372catenae
cayenne1244602cayenne
clarence1246452clarence
credence1387822credence
decadence1555592decadence
faience1237512faience
valence1268772valence
absence1137703absence
academe1244703acade_me
accedence1344573accedence
accidence1344613accidence
achene11313813achen_e
adduce1076453_adduce
adenine8311213_adenine
adenyl1035023_adenyl
adunc837433_adunc_
advance1346043_advance
advice12107883_advice
agency1237033_agency
agene65621583_agen_e
akene95818663_aken_e
amerce10310513_amerce
ardency1346483ardency
arene55329413_aren_e
audience1146583audience
avenge1087553_avenge
avenue957953_avenue
balance11510263balance
bedunce1235683bedunce
caddices14297853caddices
caddie104316453cad_die
cade76443913cad___e
cadelles1139973cadelles
cadencing1544963cadencing
cadenzas2053743cadenzas
cades85440733cade__s
cadet85339343cade__t
cadets96316513cade_ts
cadge94018783cad__ge
cadmic1338983cadmic_
cadre85419023cad__re
caducei1243873cad_ucei
caeca93915133ca_e_ca
caleche14297943caleche
calender1138273calender
calends1039523calends
camerae11312063camerae
cancel105316683ca__ncel
cancer104220923ca__ncer
candent10417363canden_t
cane66653123ca__n_e
canine83826703canin_e
cannie83819363ca_nnie
canoe75627253ca__noe
caprice1349683caprice
carinae94318583carinae
carnie84421093ca_rnie
caruncle1244713caruncle
casease939323casease
caseate9314783caseate
caseic103212373caseic_
caseose939163caseose
caserne93710063caserne
casette9310393casette
cassene93111543cassen_e
catena8312483caten_a
catenas9313113catenas
catenate10312833catenate
catface1436763catface
cayenned1443163cayenned
cayennes1345013cayennes
cense75121403c__ense
chance134617093c_hance
clarences1346453clarences
clench133910053c_lench
coagency1644863coagency
coalesce1245423coalesce
codec107120343code_c_
codecs115112933code_cs
codeine103815033codeine
coden86128543coden__
codens94821013coden_s
coerce10310403c_oerce
cogency1547013cogency
commence16149103commence
condense1179613condense
covalence1645843covalence
credences1498143credences
cymene1377393cymen_e
dance85223133__dance
decadences1665143decadences
decadency1863673decadency
defence1339893defence
deice84320033__deice
dene56643413__den_e
dense65923503__dense
deuce84517493__deuce
dunce86319263__dunce
essence947673essence
evidence1446553evidence
faiences1337043faiences
fence105319913__fence
hance105424153ha__nce
hence104920043__hence
incidence1447593incidence
indene73215373inden_e
jadeite1546403jadeite
jaunce15367433ja_unce
laden65022193laden__
ladened979053ladened
ladens74516233laden_s
lance75126723la__nce
latency1236033latency
launce8469183la_unce
licence11119363licence
lucence11148003lucence
nance74721843na__nce
nascence1256183nascence
offence1545353offence
patency1466313patency
patience1247523patience
pence94924453__pence
potence11711363potence
prudence1346333prudence
pudency1544763pudency
radiance1148123radiance
rance75028513ra__nce
refence12312233refence
salience10117903salience
sapience12106613sapience
scalene9310773scalen_e
scavenge1442813scavenge
science1138783science
silence9310213silence
spence103813793_spence
tangence1146703tangence
tendence1148523tendence
thence112010843_thence
unfence1239193unfence
valance1269253valance
valences1388513valences
valency1565463valency
whence14187923_whence

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271526.89019452.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.35924282.0
 
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.