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

120 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
biasnesses123696(None) 
badnesses1239252b_adnesses
basenesses12310562b_asenesses
bassnesses1136842bassnesses
biasness1035812biasne_s_s
bignesses1267962bi_gnesses
brashnesses1646552brashnesses
airinesses102613613airinesses
assesses737383__assesses
awaynesses1644273awaynesses
baldnesses1337653baldnesses
barenesses12311703barenesses
baronesses1238913baronesses
beadinesses1449563beadinesses
biasses94911653bia___sses
bittinesses13148263bittinesses
blacknesses1944993blacknesses
blandnesses1446623blandnesses
blanknesses1744933blanknesses
bleaknesses1744033bleaknesses
blindnesses1446183blindnesses
bluenesses1237933bluenesses
bogusnesses1444843bogusnesses
boldnesses1337233boldnesses
boninesses121111453boninesses
bossinesses12117353bossinesses
boxinesses19127903boxinesses
brassinesses1346063brassinesses
bravenesses1647953bravenesses
briefnesses1644943briefnesses
brininesses1338983brininesses
brisknesses1745583brisknesses
broadnesses1446193broadnesses
businesses121411373businesses
busynesses15145503busynesses
crassnesses1246653crassnesses
deadnesses1238943deadnesses
deafnesses1436223deafnesses
dearnesses1139583dearnesses
dimnesses1238213di_mnesses
direnesses11311483direnesses
ditsinesses12108763ditsinesses
drabnesses1336483drabnesses
easinesses10314443_easinesses
fairnesses1357383fairnesses
farnesses122310813_farnesses
fastnesses1389083_fastnesses
fatnesses121710463_fatnesses
finenesses13310713finenesses
finesses111912343fi__nesses
firmnesses1535613firmnesses
firstnesses1445733firstnesses
fitnesses12219373fi_tnesses
flatnesses1337763flatnesses
gastnesses11129143_gastnesses
gaynesses1336563_gaynesses
giantesses1143513giantesses
gladnesses1236683gladnesses
graynesses1436143graynesses
harnesses121812073_harnesses
highnesses1746083highnesses
hipnesses1436753hi_pnesses
icinesses11310073_icinesses
illnesses937283_illnesses
kindnesses1537213kindnesses
laxnesses1646633_laxnesses
leannesses10108343leannesses
likenesses1449533likenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lionesses939433li_onesses
litenesses10513023litenesses
livenesses13411073livenesses
madnesses1239833_madnesses
meannesses12128163meannesses
mildnesses1397393mildnesses
mirinesses121512313mirinesses
nearnesses1039103nearnesses
neatnesses10310013neatnesses
nicenesses12310353nicenesses
nighnesses1446463nighnesses
oilinesses101512443oilinesses
ovalnesses1346053ovalnesses
pastnesses12910513_pastnesses
patnesses111611793_patnesses
pinknesses1636583pinknesses
piousnesses1348983piousnesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
rashnesses1338723_rashnesses
rawnesses1288123_rawnesses
realnesses10310853realnesses
reassesses945063reassesses
richnesses1537803richnesses
rifenesses1339943rifenesses
riminesses121211413riminesses
ripenesses12310373ripenesses
sadnesses10310303_sadnesses
sicknesses1636763sicknesses
sissinesses9118313sissinesses
sissynesses12123423sissynesses
sizinesses1938653sizinesses
tidinesses1139223tidinesses
tininesses10311163tininesses
tipsinesses1336363tipsinesses
titanesses1037253titanesses
vainnesses1337343vainnesses
vastnesses13128203_vastnesses
vilenesses13310223vilenesses
vitalnesses1456273vitalnesses
waenesses1239773_waenesses
wannesses1239233_wannesses
weaknesses1735463weaknesses
whatnesses1635733whatnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
wirinesses131811523wirinesses
wisenesses13310823wisenesses
witnesses12219923wi_tnesses

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.406440125.6
2DLD Change Limit1406031207.47018822.4
3Display Results1201200.123975.6
 (SQL Overall)1786911207.99922339.2
 
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.