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

154 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
cadences133847(None) 
cadence1239061cadence_
cadenced1435521cadenced
cadencies1447321cadencies
caddices14297852caddices
cadelles1139972cadelles
cadency1545892cadenc_y
cadenzas2053742cadenzas
cayennes1345012cayennes
clarences1346452clarences
credences1498142credences
decadences1665142decadences
faiences1337042faiences
valences1388512valences
absences1247673absences
academes1344873acade_mes
academies1444683academies
accedences1454163accedences
accidences1444403accidences
achenes12313493achen_es
adduces1185763_adduces
adenines9310193_adenines
adenoses947903_adenoses
adenyls1143923_adenyls
advances1445613_advances
advices13136933_advices
agencies1138743_agencies
agenes74720253_agen_es
akenes104817343_aken_es
amerces1149853_amerces
ardencies1247853ardencies
arenes64928393_aren_es
audiences1246003audiences
avenges1157543_avenges
avenses1049643_avenses
avenues1057183_avenues
balances1279973balances
bedunces1345513bedunces
caddice13327733caddice_
caddies113718383cad_dies
caddises12329353caddises
cadelle1039923cadelle_
cadencing1544963cadencing
cadent94120363caden__t
cadenza1943773caden_za
cades85440733cad___es
cadets96316513cade__ts
cadges104716713cad__ges
cadres94017933cad__res
caducei1243873cad_ucei
caduceus1342573cad_uceus
cajones163311333cajon_es
calces104420053ca__lces
caleches15269933caleches
calender1138273calender
calenders1237403calenders
calends1039523calen_ds
calices114321693ca_lices
calyces14428803ca_lyces
cancel105316683ca__ncel
cancels114113313ca__ncels
cancer104220923ca__ncer
cancers114018583ca__ncers
canes75350373ca__n_es
canines93724033canin_es
canoes84725883ca__noes
caprices1439893caprices
caresses10314063caresses
carices114220953ca_rices
carnies94123963ca_rnies
caruncles1345003caruncles
caseases10410473caseases
caseates10313713caseates
casefies1339213casefies
caseoses1039293caseoses
casernes103810753casernes
casettes1039653casettes
cassenes103611293cassen_es
catenae9311373catenae_
catenas9313113caten_as
catenates11311813catenates
catfaces1536963catfaces
caudexes1843843caude_xes
caudices13337343caudices
cayenne1244603cayenne_
cayenned1443163cayenned
censes83721803c__enses
chances145218093c_hances
clarence1246453clarence_
clenches152910953c_lenches
coagencies1545623coagencies
coalesces1346043coalesces
codecs115112933code_c_s
codeines113114523codeines
codens94821013coden__s
codices12512583cod_ices
coerces11311943c_oerces
cogencies1448103cogencies
commences17139583commences
condenses12710133condenses
covalences1745833covalences
credence1387823credence_
cymenes1477413cymen_es
dances95120653__dances
decadence1555593decadence_
decadencies1753873decadencies
defences1439633defences
deices94119373__deices
denes65639723__den_es
denies74729643__denies
deuces94015513__deuces
dunces95215753__dunces
essences1047563essences
evidences1556333evidences
faeces114713123fa_e_ces
faience1237513faience_
fences114617113__fences
hances115621283ha__nces
incidences1547133incidences
indenes82916253inden_es
jadeites1645823jadeites
jaunces16307423ja_unces
ladened979053laden_ed
ladens74516233laden__s
lances84824103la__nces
latencies1147773latencies
launces9329003la_unces
licences12129323licences
lucences12137313lucences
nances83618643na__nces
nascences1346233nascences
offences1645023offences
patencies1349173patencies
patiences1367433patiences
potences12710693potences
prudences1446683prudences
pudencies1445783pudencies
radiances1247693radiances
radices102314263rad_ices
rances84625443ra__nces
redenies9615713redenies
refences13311843refences
saliences11108063saliences
sapiences13116423sapiences
scavenges1542903scavenges
sciences1238773sciences
silences10310073silences
spences113413923_spences
tangences1246443tangences
tendences1248083tendences
unfences1337933unfences
valances1398763valances
valence1268773valence_
valencies1446413valencies

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.436409841.7
2DLD Change Limit1461621547.61019206.6
3Display Results1541540.0632444.4
 (SQL Overall)1786911548.10922036.1
 
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.