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

189 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
cascade1211860(None) 
cascaded14135701cascaded
cascades13128551cascades
alcade91111512_alcade
arcade91013642_arcade
carcase11312732carcase
cascabel14174502cascabel
cascable141510622cascable
cascara1138312cascara
casease939322casease
caseate9314782caseate
facade1238802fa_cade
passade1039232passade
saccade12107032saccade
abrade9313053_abrade
accede1138293_accede
alcades101011473_alcades
alcaide1088453_alcaide
alcalde10104953_alcalde
alcayde13103723_alcayde
arcaded1178973_arcaded
arcades101113193_arcades
arcane81216743_arcane
ascared10399523_ascared
ashcake1663373_ashcake
aside65122083_as_ide
aubade939223_aubade
baccae12119703bacca_e
baccate131011263baccate
ballade104012563ballade
bascule1136573bascule
boscage1276533boscage
brocade1238533brocade
cabbage1446983cabbage
caca85528083ca_ca__
cacao95420003ca_ca_o
cacaos104616183ca_caos
cacas95627983ca_ca_s
cache125122483ca_c_he
cached145419203ca_ched
cackle143416923ca_ckle
cade76443913___cade
caeca93915133caeca__
caecal103713733caeca_l
calcanea1276273calcanea
calcanei1265263calcanei
calcar10312753calca_r
calcars11312653calcars
calceate1239863calceate
calcine11315273calcine
calcite11413783calcite
calycate1537893calycate
camisade1374823camisade
canape10913513ca_nape
cancan10314103canca_n
cancans11311873cancans
carafe115416163ca_rafe
carate84734003ca_rate
carbide126112493carbide
carcanet12316343carcanet
carcases12313083carcases
carcass11310513carcass
cardcase1345963cardcase
carfare12310073carfare
carnage10311743carnage
carpale113414353carpale
cartage10312593cartage
casa65630863cas_a__
casaba1079263cas_aba
casas75327843cas_a_s
casava1157873cas_ava
casbah1337903casba_h
casbahs1436463casbahs
cascabels15163233cascabels
cascables15165773cascables
cascading1545673cascading
cascaras1237703cascaras
case65848083cas___e
caseases10410473caseases
caseated11310713caseated
caseates10313713caseates
cased86032413cas_ed_
casemate1239843casemate
caseose939163caseose
caserne93710063caserne
casette9310393casette
cashable15159793cashable
cashaw14439793casha_w
cashaws15398573cashaws
cashed125124353cashed_
casked134815513casked_
casque17299273cas_que
casqued19235633casqued
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassene93111543cassene
cassine93817283cassine
castable121613973castable
castanet10416193castanet
caste75932363cas__te
castle84918963cas_tle
castled104311513castled
castrate10313863castrate
casual81112863casua_l
casuals91410523casuals
catcall1139153catcall
catface1436763catface
cathode1338993cathode
caudad10157673caudad_
caudate10311353caudate
cavalcade1742053cavalcade
caviare1238373caviare
cestode1037963cestode
chamade15138453chamade
charade13129913charade
chicane1489553chicane
cicada1136413c_icada
cicadae1244853c_icadae
cicale10314503c_icale
clade85821013c__lade
cockade1638133cockade
comade114415323c_omade
comrade12139213comrade
concave1439373concave
concede12310093concede
corrade101111043corrade
costae85319683costa_e
costate94019273costate
couvade1335063couvade
crusade1036053crusade
cupcake1743953cupcake
cuspate1138233cuspate
cycad13507273c_ycad_
cycads14476213c_ycads
daycare1355093daycare
decade104216163_decade
discase102912863discase
escape103811663_escape
facades1339033fa_cades
falcate12311613falcate
fasciae1247523fasciae
fasciate1347563fasciate
fascine12510583fascine
gambade1336383gambade
gasconade1343163gasconade
hastate10313913hastate
inscape1138013inscape
lascar868573lasca_r
lascars979013lascars
manmade1237963manmade
mascara1138023mascara
massage1039893massage
miscode12310413miscode
mismade12129353mismade
muscadel1343763muscadel
muscadet1348143muscadet
muscae10410673musca_e
oatcake1345363oatcake
pancake1536673pancake
parade94720643pa_rade
parkade1437583parkade
pascal10812373pasca_l
pascals11610013pascals
passades1139203passades
passado1037053passado
passage1039803passage
pesade9311103pes_ade
rascal8511123rasca_l
rascals959663rascals
rescale93215473rescale
respade1039573respade
saccades13137253saccades
saccate111311763saccate
sade55544473__s_ade
scad75725773__scad_
scads85419963__scads
scalade10359263sca_lade
scale74629143__scale
scape96921843__scape
scare75334463__scare
seascape1245173seascape
shade95125583__shade
spade84423323__spade
stade64825303__stade
tsade64311123_ts_ade
upscale11136323upscale
vacate11314553va_cate
wastage11109253wastage

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.1561145455.1
2DLD Change Limit1340271896.07622058.4
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.29528386.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.