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

215 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
latenesses1041335(None) 
lamenesses12610561lamenesses
litenesses10513001litenesses
barenesses12311692barenesses
basenesses12310552basenesses
cateresses1248352cateresses
cutenesses12910872cutenesses
datednesses1357892datednesses
elatednesses1346092elatednesses
fatnesses121710462fat_nesses
flatnesses1337762flat_nesses
gamenesses1368982gamenesses
halenesses13312032halenesses
iratenesses11411402iratenesses
lacinesses12312102lacinesses
lanknesses1437502lanknesses
largenesses1247552largenesses
lateness82614072latene_s_s
laxnesses1646632la_xnesses
lazinesses19310142lazinesses
likenesses1449532likenesses
lithenesses1447302lithenesses
livenesses13411052livenesses
loathnesses1445852loathnesses
lonenesses10311342lonenesses
malenesses12312202malenesses
mateynesses1645162mateynesses
matinesses12314522matinesses
mutenesses1289932mutenesses
oblatenesses1475762oblatenesses
palenesses12312652palenesses
patnesses111611792pat_nesses
planenesses1349032planenesses
rarenesses10313092rarenesses
safenesses1349372safenesses
sagenesses11510822sagenesses
samenesses12410852samenesses
sanenesses10412692sanenesses
slatinesses11311612slatinesses
tamenesses1259962tamenesses
waenesses1239772wa_enesses
acutenesses13126953acutenesses
agednesses1237413_agednesses
ageneses939303_agene_ses
aliennesses1145863aliennesses
alikenesses1547193alikenesses
alivenesses1448853alivenesses
alonenesses1147213alonenesses
aptnesses11168993_aptnesses
artinesses10815193artinesses
awarenesses1447253awarenesses
badnesses1239243ba_dnesses
baldnesses1337643baldnesses
baronesses1238903baronesses
bassnesses1136833bassnesses
battinesses13169443battinesses
belatednesses1644313belatednesses
blacknesses1944993blacknesses
blandnesses1446623blandnesses
blanknesses1744933blanknesses
bluenesses1237923bluenesses
bravenesses1647943bravenesses
cageynesses1743873cageynesses
caginesses13310933caginesses
cakinesses16310603cakinesses
calmnesses1436833calmnesses
canonesses1238413canonesses
cattinesses13129703cattinesses
chastenesses1746303chastenesses
closenesses1347843closenesses
daftnesses1436383daftnesses
dampnesses1535603dampnesses
danknesses1536253danknesses
darknesses1537013darknesses
dazednesses2245153dazednesses
dilutenesses1346103dilutenesses
direnesses11311483direnesses
donenesses11310563donenesses
duenesses1039323_duenesses
eagernesses1246973eagernesses
easinesses10314413easinesses
fadednesses16126563fadednesses
fairnesses1357383fairnesses
falsenesses1446743falsenesses
farnesses122310813fa_rnesses
fastnesses1389073fastnesses
fatalnesses1456263fatalnesses
fattinesses14118973fattinesses
finenesses13310713finenesses
fitnesses12219373fit_nesses
flakinesses1837073flakinesses
fleetnesses1445483fleetnesses
freenesses1339863freenesses
gaminesses13410453gaminesses
gastnesses11129133gastnesses
gaynesses1336563ga_ynesses
gladnesses1236683gla_dnesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
gonenesses11310253gonenesses
gravenesses1548163gravenesses
halfnesses1636263halfnesses
hardnesses141810543hardnesses
harnesses121812073ha_rnesses
hastinesses141210683hastinesses
hazinesses2239213hazinesses
hotnesses1238903hot_nesses
hugenesses1437133hugenesses
idlenesses1138023idlenesses
inanenesses1149513inanenesses
innatenesses1247173innatenesses
jadednesses20145773jadednesses
lameness102612673lamene_s_s
lankinesses1539013lankinesses
largesses10246273la_rgesses
larkinesses1538993larkinesses
latencies1147773laten_cies
leadennesses1354573leadennesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leannesses10108343leannesses
levelnesses1445533levelnesses
lewdnesses1435393lewdnesses
liminesses121310843liminesses
limpnesses14116653limpnesses
lionesses939423l_ionesses
liteness82213213litene_s_s
littlenesses1246073littlenesses
loaminesses1358443loaminesses
loftinesses1437913loftinesses
loginesses11410313loginesses
longnesses1138503longnesses
loosenesses1147233loosenesses
lornnesses1037823lornnesses
lostnesses1049293lostnesses
loudnesses1138433loudnesses
lownesses1236983l_ownesses
lushnesses1337333lushnesses
lustinesses11910403lustinesses
madnesses1239833ma_dnesses
maltinesses13310223maltinesses
matelasses1253993matelasses
mattresses1245433mattresses
mazednesses2345403mazednesses
mazinesses2139903mazinesses
meatinesses13311973meatinesses
meetnesses1237443meetnesses
morenesses12811383morenesses
naivenesses1449083naivenesses
nakednesses1645843nakednesses
nastinesses111110723nastinesses
nativenesses1548533nativenesses
nattinesses11119313nattinesses
neatnesses10310003neat_nesses
nicenesses12310333nicenesses
notednesses1247773notednesses
nudenesses1157853nudenesses
onenesses9311823_onenesses
ornatenesses1257283ornatenesses
packnesses1856623packnesses
pastinesses13911703pastinesses
pastnesses12910503pastnesses
patronesses1346473patronesses
plainnesses1356203plainnesses
politenesses1448553politenesses
purenesses12810723purenesses
racinesses12313493racinesses
ranknesses1438093ranknesses
raptnesses1248523raptnesses
rashnesses1338713rashnesses
rawnesses1288123ra_wnesses
relatednesses1444983relatednesses
rifenesses1339933rifenesses
ripenesses12310363ripenesses
rudenesses1188863rudenesses
sadnesses10310303sa_dnesses
saltinesses11311443saltinesses
saltnesses10310163saltnesses
sedatenesses1346943sedatenesses
slacknesses1745233slacknesses
solenesses10412703solenesses
sorenesses101313483sorenesses
sparenesses1339173sparenesses
stalenesses11311083stalenesses
suavenesses1448393suavenesses
surenesses101212203surenesses
tallnesses1037463tallnesses
tartinesses111011493tartinesses
tartnesses101110713tartnesses
tastinesses111110773tastinesses
tattinesses11128943tattinesses
tautnesses10118283tautnesses
titanesses1037233titanesses
tritenesses11710353tritenesses
truenesses1039313truenesses
tweenesses1345803tweenesses
utternesses1145873utternesses
vaguenesses1544813vaguenesses
vainnesses1337343vainnesses
vastnesses13128193vastnesses
vilenesses13310213vilenesses
wannesses1239233wa_nnesses
warinesses131514513warinesses
warmnesses15167353warmnesses
waterinesses1567193waterinesses
wavinesses16199273wavinesses
waxinesses20138753waxinesses
wetnesses12208213wet_nesses
whatnesses1635733what_nesses
whitenesses1746633whitenesses
widenesses1438773widenesses
wisenesses13310803wisenesses
witnesses12219923wit_nesses
woenesses1239133_woenesses
zaninesses19310373zaninesses

Search took 9 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 Filter1786911406030.1701051123.5
2DLD Change Limit1406032157.65618365.1
3Display Results2152150.1731242.8
 (SQL Overall)1786912157.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.