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 “dappernesses” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
dappernesses174324(None) 
dapperness1543152dapperne_s_s
adaptednesses1772623adaptednesses
dampnesses1535603damp__nesses
datednesses1357903da_tednesses
dazednesses2245153da_zednesses
dippinesses1635243dipp_inesses
dopeynesses1744023d_opeynesses
eagernesses1246983ea_gernesses
happinesses1876163happ_inesses
nappinesses1555923napp_inesses
paperinesses1646053pa_perinesses
pepperinesses1653273pepperinesses
propernesses1645013propernesses
sappinesses1567563sapp_inesses
adeptnesses1444834adep_tnesses
agednesses1237414_a_gednesses
alertnesses1147234_a_lertnesses
aliennesses1145864_aliennesses
amplenesses1585704_amplenesses
apartnesses1346824_apartnesses
aphereses1466424_apher_e_ses
apishnesses1646374_apishnesses
apperceives2052804_apperceives
appressed1445944_app_r_essed
aptnesses11168994_a_p_tnesses
askewnesses1842664_askewnesses
awarenesses1447254_awarenesses
barenesses12311704ba_re_nesses
barrennesses1443434barrennesses
basenesses12310564ba_se_nesses
bitternesses1444534bitternesses
cageynesses1743874ca_geynesses
campinesses1737114camp_inesses
cateresses1248354ca_ter_esses
clevernesses1743634clevernesses
daffinesses1834844da_ffinesses
daftnesses1436384da__ftnesses
dailinesses1249494da_ilinesses
dailynesses1543944da_ilynesses
daintinesses1346244daintinesses
danknesses1536254da__nknesses
dapperest1445284dapper_e_s_t
daringnesses1464834daringnesses
darknesses1537014da__rknesses
dearnesses1139584d__earnesses
deepnesses1366674d__eepnesses
demurenesses1544754demurenesses
densenesses1247364dense_nesses
depresses1259884d_ep_r_esses
derepresses1444774derepr_esses
direnesses11311484d_ire_nesses
doggednesses1643704doggednesses
donenesses11310564d_one_nesses
dopinesses13159724d_op_inesses
dournesses1138244d__ournesses
drivennesses1643834drivennesses
duenesses1039334d__ue_nesses
dumpinesses16126254dump_inesses
expertnesses2144844_expertnesses
fadednesses16126564fa_dednesses
fairnesses1357384fa__irnesses
falsenesses1446744false_nesses
farnesses122310814fa___rnesses
gamenesses1368984ga_me_nesses
governesses1546724_governesses
halenesses13312044ha_le_nesses
handednesses1765644handednesses
haplessnesses1747254haplessnesses
harnesses121812074ha___rnesses
hippienesses1943444hippienesses
hippinesses1845494hipp_inesses
impropernesses20101474impropernesses
impurenesses16164434impurenesses
innernesses1146734_innernesses
invernesses1447034_invernesses
jadednesses20145774ja_dednesses
jaggednesses2242794jaggednesses
lamenesses12610564la_me_nesses
largenesses1247554large_nesses
latenesses10413364la_te_nesses
limbernesses1643154limbernesses
lippinesses1535514lipp_inesses
malapertnesses1881384malapertnesses
malenesses12312224ma_le_nesses
markednesses1944184markednesses
mateynesses1645174ma_teynesses
mazednesses2345404ma_zednesses
meagernesses1544444meagernesses
naivenesses1449114naive_nesses
nakednesses1645844na_kednesses
nippinesses1545064nipp_inesses
opennesses1246314__opennesses
oppresses1346874_opp_r_esses
othernesses1475424_othernesses
palenesses12312664pa_le_nesses
peeresses1138474__peer_esses
peppinesses1435314pepp_inesses
pertnesses12310314___pertnesses
poornesses1236804__poornesses
purenesses12810744__purenesses
queernesses2044574_queernesses
raggednesses1543864raggednesses
rapidnesses1476474ra_pidnesses
raptnesses1248524ra_p_tnesses
rarenesses10313114ra_re_nesses
raspinesses1338014rasp_inesses
ripenesses12310374_ripe_nesses
sacrednesses1544874sacrednesses
safenesses1349374sa_fe_nesses
sagenesses11510824sa_ge_nesses
samenesses12410854sa_me_nesses
sanenesses10412694sa_ne_nesses
saplessnesses1347274saplessnesses
sheernesses1445844_sheernesses
slipperinesses1851854slipperinesses
snappinesses1684324snapp_inesses
sobernesses1346594_sobernesses
sombernesses1643614sombernesses
soppinesses1566844sopp_inesses
sparenesses1339174spare_nesses
superbnesses1695564_superbnesses
supplenesses1643984supplenesses
suppresses1446254supp_r_esses
tamenesses1259974ta_me_nesses
tendernesses1345074tendernesses
utternesses1145874_utternesses
vaguenesses1544814vague_nesses
vapidnesses1774894va_pidnesses
waenesses1239774wa__e_nesses
waspinesses1636704wasp_inesses
waterinesses1567194wa_terinesses
wildernesses1643624wildernesses

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901336.95317947.6
3Display Results1331330.0801662.5
 (SQL Overall)1786911337.42324072.6
 
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.