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

145 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
cascara113831(None) 
cascaras1237701cascaras
mascara1138021mascara
baccara1347142baccara
calcar10312752calcar_
calcaria1249532calcaria
calcars11312652calcars
caracara1247252caracara
casaba1079262cas_aba
casava1157872cas_ava
cascade12118602cascade
cassaba1145662cassaba
cassata938142cassata
cassava1255002cassava
lascar868572lascar_
lascars979012lascars
mascaras1237692mascaras
acari75020283_a_cari
arcana8912583_arcana
asana5315483_as_ana
ascared10399523_ascared
ascarid103910723_ascarid
ascaris93613323_ascaris
asrama839193_asrama
aswarm11107913_aswarm
baccaras1446913baccaras
baccarat1447933baccarat
bastard103012423bastard
cabala103516913ca_bala
cabana103913563ca_bana
cabbala1367183cabbala
caca85528083ca_c__a
cacao95420003ca_ca_o
cacaos104616183ca_caos
cacas95627983ca_ca_s
caeca93915133caec__a
caecal103713733caeca_l
caesar8410933caesar_
caesars9410733caesars
caesura956233caesura
calcanea1276283calcanea
calcarate1347703calcarate
caldaria1148953caldaria
caldera1037963caldera
calvaria1347893calvaria
calvary1537183calvary
camera10313693ca_mera
camorra11115763camorra
canard9314763ca_nard
canary11314693ca_nary
cancan10314103canca_n
cancans11311873cancans
cancer104220923cancer_
cancers114018583cancers
cancha134411613canc_ha
cantala94114673cantala
cantata93811813cantata
capybara1742783capybara
caracaras1346863caracaras
carbarn1139453carbarn
carbora11310703carbora
carcase11312743carcase
carcass11310513carcass
carceral1247203carceral
carfare12310073carfare
casa65630863cas___a
casabas1139983cas_abas
casas75327843cas_a_s
casavas1237823cas_avas
casbah1337903casba_h
casbahs1436463casbahs
cascabel14174503cascabel
cascable141510623cascable
cascaded14135703cascaded
cascades13128553cascades
cascarilla1452213cascarilla
casease939323casease
caseate9314783caseate
casern84713313cas_ern
cashaw14439793casha_w
cashaws15398573cashaws
casita82913703cas_ita
cassabas1245733cassabas
cassatas1036683cassatas
cassavas1344803cassavas
cassena9287843cassena
cassia83714763cas_sia
cassina94113163cassina
castaway1664573castaway
caster85232573caster_
casters94729903casters
castor84418533castor_
castors94919443castors
casual81112863casua_l
casuals91410523casuals
casuarina1144973casuarina
catcall1139153catcall
caviar11310163caviar_
caviare1238373caviare
caviars1238623caviars
cercaria1246963cercaria
cesura838763ces_ura
cicada1136413c_icada
cicala10310053c_icala
cithara12166513cithara
costar85518613costar_
costard104113353costard
costars94218013costars
curara83712203c_urara
custard10389973custard
dastard9279703dastard
daycare1355093daycare
discard11310213discard
escar74011993_escar_
escarp10449003_escarp
escars83913133_escars
fascia1148703fasc_ia
haftara13136093haftara
jacana1537933ja_cana
labara83712893la_bara
masala8311813mas_ala
mascaraed1454093mascaraed
mastaba1146223mastaba
pascal10812373pasca_l
pascals11610013pascals
picara10311903_picara
piscary1437423piscary
rasbora945943rasbora
rascal8511123rasca_l
rascals959663rascals
sacra74516993sa_c_ra
samara8313853sa_mara
samsara936913samsara
satara6315533sa_tara
scar66434203__scar_
scarab10310063__scarab
scare75334463__scare
scarf105427143__scarf
scarp95724103__scarp
scars75433533__scars
scart76139773__scart
scary105222593__scary
tantara72410823tantara
vascula1245853vascula
viscera1235083viscera

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.403443402.0
2DLD Change Limit1340271457.23618522.2
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.68523251.9
 
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.