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

171 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
bignesses126795(None) 
badnesses1239242badnesses
biasnesses1236942biasnesses
bigness1038192bigne_s_s
digresses1137862digresses
dimnesses1238212dimnesses
finesses111912332fi_nesses
fitnesses12219372fitnesses
highnesses1746082highnesses
hipnesses1436752hipnesses
lionesses939422lionesses
nighnesses1446462nighnesses
tigresses1046402tigresses
trignesses1188212trignesses
witnesses12219922witnesses
acidnesses1337253acidnesses
aggresses1146143aggresses
airinesses102613603airinesses
aptnesses11168993aptnesses
aridnesses1139933aridnesses
avidnesses1436463avidnesses
bagasses1136313bag_asses
bagginesses1545943bagginesses
baldnesses1337643baldnesses
barenesses12311693barenesses
baronesses1238903baronesses
basenesses12310553basenesses
bassnesses1136833bassnesses
biasses94911653bi__asses
bicepses1443873bi_cepses
bigeyes1335653big_e_yes
bigoses1039073big__oses
biogasses1244003biogasses
biogeneses1346013biogeneses
biomasses1343963biomasses
bittinesses13148253bittinesses
blesses93812393b__lesses
blindnesses1446183blindnesses
bluenesses1237923bluenesses
bogginesses1555663bogginesses
bogusnesses1444833bogusnesses
boldnesses1337223boldnesses
boninesses121111443boninesses
boringnesses15105013boringnesses
boxinesses19127893boxinesses
briefnesses1644943briefnesses
brightnesses1844183brightnesses
brininesses1338973brininesses
brisknesses1745573brisknesses
bugginesses1545363bugginesses
buglosses1243543buglosses
bulginesses1466123bulginesses
burgesses1245503burgesses
businesses121411353businesses
busynesses15145493busynesses
caginesses13310933caginesses
chicnesses1745203chicnesses
coynesses1437573coynesses
digeneses1147393digeneses
digressed1245613digressed
dinginesses1337473dinginesses
direnesses11311483direnesses
drynesses1335363drynesses
duenesses1039323duenesses
dulnesses1037743dulnesses
dunnesses1037693dunnesses
edginesses1236683edginesses
egresses949443_egresses
evilnesses1345983evilnesses
fairnesses1357383fairnesses
farnesses122310813farnesses
fatnesses121710463fatnesses
fewnesses1534953fewnesses
feynesses1535223feynesses
finenesses13310713finenesses
finesse10187643fi_nesse_
finessed12136793fi_nessed
firmnesses1535613firmnesses
fulnesses1239033fulnesses
gaynesses1336563gaynesses
giantesses1143513giantesses
glegnesses1245073glegnesses
glibnesses1344753glibnesses
gneisses933673__gneisses
grimnesses13106533grimnesses
guesses8169373__guesses
harnesses121812073harnesses
hotnesses1238903hotnesses
hugenesses1437133hugenesses
icinesses11310053icinesses
idlesses936003_idlesses
illnesses937273illnesses
ingresses1038533ingresses
kindnesses1537213kindnesses
kineses113111253ki_ne_ses
kirmesses15253903kirmesses
laxnesses1646633laxnesses
lightnesses1546143lightnesses
likenesses1449533likenesses
liminesses121310843liminesses
limpnesses14116653limpnesses
litenesses10513003litenesses
livenesses13411053livenesses
loginesses11410313loginesses
longnesses1138503longnesses
lownesses1236983lownesses
madnesses1239833madnesses
mildnesses1397393mildnesses
mirinesses121512303mirinesses
misguesses1343323misguesses
nesses64718323___nesses
newnesses1236123newnesses
nicenesses12310333nicenesses
nownesses1236883nownesses
oddnesses1136353oddnesses
ogresses938473_ogresses
oilinesses101512433oilinesses
oldnesses1037703oldnesses
onenesses9311823onenesses
patnesses111611793patnesses
pigginesses1555613pigginesses
pinknesses1636583pinknesses
pipinesses1448593pipinesses
pixinesses1937363pixinesses
primnesses1497803primnesses
rabidnesses1476123rabidnesses
rawnesses1288123rawnesses
rednesses10312303rednesses
regresses10310463regresses
richnesses1537793richnesses
rifenesses1339933rifenesses
rightnesses1546233rightnesses
rigidnesses1345923rigidnesses
riminesses121211403riminesses
ripenesses12310363ripenesses
sadnesses10310303sadnesses
sagenesses11510823sagenesses
shynesses1535313shynesses
sicknesses1636753sicknesses
signees83510803signe__es
sizinesses1938643sizinesses
slimnesses1236423slimnesses
slynesses1235863slynesses
smugnesses1344563smugnesses
snugnesses1165423snugnesses
thingnesses1545173thingnesses
thinnesses1346253thinnesses
tidinesses1139213tidinesses
tightnesses1565583tightnesses
tininesses10311153tininesses
titanesses1037233titanesses
trimnesses1287753trimnesses
vainnesses1337343vainnesses
vignettes1344673vignettes
vilenesses13310213vilenesses
vinasses1135703vi_nasses
vitesses1136333vi_tesses
voidnesses1436833voidnesses
waenesses1239773waenesses
wannesses1239233wannesses
wetnesses12208213wetnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911083wilinesses
wirinesses131811513wirinesses
wisenesses13310803wisenesses
witnessed13214723witnessed
witnesser12224533witnesser
witnessers13173093witnessers
woenesses1239133woenesses
wrynesses1534843wrynesses

Search took 10 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411718.93616634.0
3Display Results1711710.1101554.5
 (SQL Overall)1786911719.20219418.7
 
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.