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

135 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
daresay113543(None) 
dares66146702dares__
dressy10518142d_ressy
resay85320542__resay
adrenal838263adrenal
area45843393_are_a_
areae55229743_are_ae
areal55928733_are_al
areas55935773_are_as
areaway1335913_areaway
areca75618633_areca_
arecas84817443_arecas
arena55323813_arena_
arenas65021993_arenas
arepa75615563_arepa_
arepas85515703_arepas
ares45871023_ares__
array86317143_ar_ray
artsy86012963_arts_y
assay8710283_a_ssay
barely114716793bare_ly
bares75457133bares__
baresark1443883baresark
barest85327693bares_t
caesar8410933ca_esar
calesa8412473calesa_
calesas9411833calesas
caraway1538133caraway
cares77369183cares__
caress85720263cares_s
creasy114612303_creasy
cressy11439113_cressy
daces85030683daces__
daedal849083da_edal
daisy95915313da_is_y
dales66439743dales__
dalesman1145803dalesman
dames85435853dames__
darbar959953dar_bar
darbs85323263darbs__
dare55848863dare___
dared75935013dare__d
dareful1157053dareful
darer65230793dare__r
darers75921873dare_rs
darkest122512623darkes_t
darkey145212423dar_key
darkly145411073dar_kly
darks106727873darks__
darky136018833dar__ky
darns66927893darns__
darshan1167063darshan
darts67635733darts__
dashy125612383da__shy
datedly1236023datedly
dates65639153dates__
dazedly2134063dazedly
dazes155024143dazes__
dearest83618673deares_t
decay114718483d__ecay
deejay1734523d_eejay
delay94820633d__elay
deray95024183d__eray
direly10311563dire_ly
direst75024243dires_t
domesday1542313domesday
dorsa64617283dor_sa_
dorsad8408973dor_sad
dorsal74613943dor_sal
dray85428093d_r__ay
dread74419023d_re_ad
dream85120393d_re_am
dreamy12509993d_reamy
drear65016903d_re_ar
dreary104611673d_reary
drecky16486333d_recky
dreggy12364633d_reggy
dress65319833d_res_s
drest65530343d_res_t
drosky14486163d_rosky
drossy10528473d_rossy
dures65635923dures__
duress74712063dures_s
faraday1445633faraday
faraway1645413faraway
fares85852873fares__
forebay1538133forebay
foresaw1377133foresaw
forestay1448193forestay
gainsay1144043gainsay
gateway1434933gateway
greasy10419463_greasy
hares86255543hares__
hearsay1335523hear_say
heresy125011233heres_y
laneway1345273laneway
lares54852633lares__
majesty1943503majesty
mares76457633mares__
margay12310593mar_gay
marshy14558333mar_shy
nares55544153nares__
naysay1234973na_ysay
paesan85114093pa_esan
pares77164483pares__
pareses94718883pareses
paresis93315093paresis
parkway1934553parkway
parlay113713993par_lay
parmesan1244753parmesan
partway1535923partway
prepay13310313_prepay
presa74319043_presa_
raceway1546133raceway
rarefy12296343rare_fy
rarely93513653rare_ly
rares55247443rares__
rarest65725483rares_t
relay84424673__relay
repay104818453__repay
resat55139683__resat
resaw84117253__resaw
resays93714153__resays
sarsar63011843sar_sar
tares57456563tares__
tarsal63315273tar_sal
tressy9448553_tressy
virelay1335943virelay
wares88250583wares__
warsaw1236193war_saw
wireway1646043wireway
yarely122810303yare_ly
yarest95018913yares_t
zareba1736423zareba_
zarebas1836303zarebas

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 Limit1340271355.97022450.1
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.42227824.8
 
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.