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

136 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
bassnesses113684(None) 
basenesses12310561basenesses
assesses737382_ass_esses
badnesses1239252ba_dnesses
baldnesses1337652baldnesses
barenesses12311702barenesses
baronesses1238912baronesses
bassness1096742bassne_s_s
biasnesses1236962biasnesses
bossinesses12117352bossinesses
brashnesses1646552brashnesses
brassinesses1346062brassinesses
businesses121411372businesses
busynesses15145502busynesses
crassnesses1246652crassnesses
easinesses10314442easinesses
fastnesses1389082fastnesses
gassinesses1197972gassinesses
gastnesses11129142gastnesses
massinesses12128692massinesses
pastnesses12910512pastnesses
rashnesses1338722rashnesses
sassinesses999322sassinesses
vastnesses13128202vastnesses
abscesses1344103_abscesses
aptnesses11168993_aptnesses
ashinesses1339163_ashinesses
assessed945023_ass_essed
bagginesses1545953bagginesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
baseness10910943basene_s_s
battinesses13169453battinesses
bawdinesses17126323bawdinesses
beadinesses1449563beadinesses
bignesses1267963b_ignesses
blacknesses1944993blacknesses
blandnesses1446623blandnesses
blanknesses1744933blanknesses
bluenesses1237933bluenesses
bogusnesses1444843bogusnesses
boldnesses1337233boldnesses
boninesses121111453boninesses
boskinesses17136813boskinesses
boxinesses19127903boxinesses
bravenesses1647953bravenesses
brisknesses1745583brisknesses
bushinesses16107463bushinesses
bustinesses131310093bustinesses
caginesses13310943caginesses
cakinesses16310613cakinesses
calmnesses1436843calmnesses
canonesses1238413canonesses
classinesses1366113classinesses
cosinesses121012823cosinesses
crossnesses1247123crossnesses
daftnesses1436383daftnesses
dampnesses1535603dampnesses
danknesses1536253danknesses
darknesses1537013darknesses
fairnesses1357383fairnesses
falsenesses1446743falsenesses
farnesses122310813fa_rnesses
fatnesses121710463fa_tnesses
fussinesses13126943fussinesses
gamenesses1368983gamenesses
gaminesses13410463gaminesses
gaynesses1336563ga_ynesses
glassinesses1255243glassinesses
grossnesses1146713grossnesses
halenesses13312043halenesses
halfnesses1636263halfnesses
hardnesses141810543hardnesses
harnesses121812073ha_rnesses
harshnesses1745853harshnesses
hastinesses141210693hastinesses
hazinesses2239223hazinesses
justnesses1736493justnesses
lacinesses12312123lacinesses
lamenesses12610563lamenesses
lanknesses1437503lanknesses
latenesses10413363latenesses
laxnesses1646633la_xnesses
lazinesses19310153lazinesses
lostnesses1049303lostnesses
lushnesses1337343lushnesses
madnesses1239833ma_dnesses
malenesses12312223malenesses
masseuses1144793mass_euses
matinesses12314543matinesses
mazinesses2139923mazinesses
messinesses1297513messinesses
mossinesses12117463mossinesses
mussinesses12147443mussinesses
nastinesses111110743nastinesses
nosinesses101411323nosinesses
obesenesses1346763obesenesses
packnesses1856623packnesses
palenesses12312663palenesses
pastinesses13911713pastinesses
patnesses111611793pa_tnesses
poshnesses1537463poshnesses
possesses1046323poss_esses
racinesses12313513racinesses
ranknesses1438093ranknesses
raptnesses1248523raptnesses
rarenesses10313113rarenesses
raspinesses1338013raspinesses
rawnesses1288123ra_wnesses
reassesses945063reass_esses
rosinesses101213143rosinesses
sadnesses10310303sa_dnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
sissinesses9118313sissinesses
sissynesses12123423sissynesses
tallnesses1037473tallnesses
tamenesses1259973tamenesses
tartnesses101110713tartnesses
tastinesses111110783tastinesses
tautnesses10118283tautnesses
vainnesses1337343vainnesses
waenesses1239773wa_enesses
wannesses1239233wa_nnesses
warinesses131514523warinesses
warmnesses15167353warmnesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283wavinesses
waxinesses20138763waxinesses
wisenesses13310823wisenesses
zaninesses19310383zaninesses

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 Filter1786911406030.1401276364.3
2DLD Change Limit1406031365.94023670.5
3Display Results1361360.0602266.7
 (SQL Overall)1786911366.14029102.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.