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

187 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
scarinesses133990(None) 
scalinesses1339321scalinesses
caginesses13310942_caginesses
cakinesses16310612_cakinesses
charinesses1639562charinesses
glarinesses1239512glarinesses
hoarinesses14310222hoarinesses
scantinesses1437312scantinesses
scantnesses1376532scantnesses
scarcenesses1644492scarcenesses
scariness11310182scarine_s_s
scurvinesses1743932scurvinesses
seaminesses13310752seaminesses
shadinesses1538642shadinesses
shakinesses1837612shakinesses
sharpnesses1645232sharpnesses
slatinesses11311632slatinesses
smarminesses1645102smarminesses
smartnesses1337142smartnesses
snakinesses1538552snakinesses
soapinesses1339712soapinesses
sorrinesses11310092sorrinesses
spacinesses1538102spacinesses
sparenesses1339172sparenesses
staginesses1238462staginesses
starknesses1545882starknesses
swartnesses1436712swartnesses
tearinesses11311692tearinesses
warinesses131514522_warinesses
wearinesses14310212wearinesses
achinesses1539303ac_hinesses
acridnesses1445783ac_ridnesses
airinesses102613613_airinesses
angrinesses1247283angrinesses
apartnesses1346823apartnesses
aridnesses1139933__aridnesses
artinesses10815213__artinesses
awarenesses1447253awarenesses
barenesses12311703_barenesses
baronesses1238913_baronesses
beadinesses1449563beadinesses
beerinesses1398923beerinesses
blearinesses1446543blearinesses
calmnesses1436843_calmnesses
campinesses1737113_campinesses
canninesses1368853_canninesses
canonesses1238423_canonesses
caresses10314063_car__esses
cattinesses13129703_cattinesses
corkinesses1749213_corkinesses
corninesses13410593_corninesses
cosinesses121012823_cosinesses
cozinesses21179503_cozinesses
crazinesses2237933crazinesses
curlinesses1338733_curlinesses
curtnesses1238373_curtnesses
darknesses1537013_darknesses
dearnesses1139583dear_nesses
drearinesses1347443drearinesses
dwarfnesses1843293dwarfnesses
earlinesses11311043_earlinesses
easinesses10314443_easinesses
eerinesses10612603_eerinesses
fairnesses1357383_fairnesses
farnesses122310813_far_nesses
fierinesses1439233fierinesses
flakinesses1837073flakinesses
foaminesses1658073foaminesses
furrinesses1437183furrinesses
gaminesses13410463_gaminesses
glazinesses2136403glazinesses
gorinesses11311553_gorinesses
grapinesses1438573grapinesses
hairinesses14198943hairinesses
hardinesses151110213_hardinesses
hardnesses141810543_hardnesses
harnesses121812073_har_nesses
hazinesses2239223_hazinesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
icinesses11310073ic__inesses
ickinesses1637183ic_kinesses
lacinesses12312123_lacinesses
larkinesses1538993_larkinesses
lazinesses19310153_lazinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
loaminesses1358453loaminesses
matinesses12314543_matinesses
mazinesses2139923_mazinesses
mealinesses13310973mealinesses
meatinesses13311983meatinesses
merrinesses1358263merrinesses
mirinesses121512313_mirinesses
nearnesses1039103near_nesses
peartnesses1338743peartnesses
quakinesses2436323quakinesses
racinesses12313513_racinesses
rarenesses10313113_rarenesses
readinesses12611273readinesses
sacrednesses1544873sacrednesses
sadnesses10310303s_a_dnesses
safenesses1349373s_afenesses
sagenesses11510823s_agenesses
saltinesses11311453saltinesses
saltnesses10310163s_altnesses
samenesses12410853s_amenesses
sandinesses12911393sandinesses
sanenesses10412693s_anenesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savorinesses1544613savorinesses
savvinesses1735663savvinesses
scaliness1149303scaline_s_s
scrappinesses1952293scrappinesses
scrawninesses1842423scrawninesses
screwinesses1744743screwinesses
securenesses1445673securenesses
seedinesses1259203seedinesses
sexinesses1739213s_exinesses
shabbinesses1953433shabbinesses
shagginesses1743963shagginesses
shininesses1448293shininesses
shortnesses1446793shortnesses
showinesses1735993showinesses
sicklinesses1844863sicklinesses
silkinesses1557903silkinesses
sillinesses1169843sillinesses
sissinesses9118313sissinesses
sizinesses1938653s_izinesses
slacknesses1745243slacknesses
slanginesses1346963slanginesses
sleazinesses2145373sleazinesses
sliminesses1338093sliminesses
smallnesses1344963smallnesses
smokinesses1736253smokinesses
snappinesses1684323snappinesses
sneakinesses1645903sneakinesses
snowinesses1436413snowinesses
sogginesses1346773sogginesses
sootinesses11410053sootinesses
soppinesses1566843soppinesses
sorenesses101313493s_orenesses
sournesses10310013sour_nesses
sparsenesses1345803sparsenesses
spicinesses1547103spicinesses
spikinesses1746523spikinesses
spininesses1358453spininesses
sportinesses1447873sportinesses
sprynesses1544973s_prynesses
squarenesses2144973squarenesses
staidnesses1237193staidnesses
stainlesses1144163sta_inlesses
stalenesses11311103stalenesses
starchinesses1843213starchinesses
steadinesses1346903steadinesses
steaminesses1446223steaminesses
sternnesses1146633sternnesses
stoninesses1138253stoninesses
storminesses1445033storminesses
straitnesses1246213straitnesses
sturdinesses1345793sturdinesses
suavenesses1448423suavenesses
sulkinesses1557723sulkinesses
sultrinesses1245883sultrinesses
sunninesses11148383sunninesses
surenesses101212213s_urenesses
surlinesses11310053surlinesses
swampinesses1943713swampinesses
swankinesses1944783swankinesses
swarthinesses1943453swarthinesses
sweatinesses1546913sweatinesses
tackinesses1737253tackinesses
tardinesses121110243_tardinesses
tarrinesses11129083tarrinesses
tartinesses111011503_tartinesses
tartnesses101110713_tartnesses
unwarinesses1546153unwarinesses
wackinesses2036653wackinesses
warmnesses15167353_warmnesses
wavinesses16199283_wavinesses
waxinesses20138763_waxinesses
wirinesses131811523_wirinesses
zaninesses19310383_zaninesses

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331874.86025027.4
3Display Results1871870.1261484.1
 (SQL Overall)1786911875.37633238.7
 
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.