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

175 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
finenesses1331071(None) 
direnesses11311482direnesses
donenesses11310562donenesses
faintnesses1447142faintnesses
fineness11310642finene_s_s
finesses111912332fi__nesses
finitenesses1557692finitenesses
firmnesses1535612firmnesses
fitnesses12219372fi_tnesses
fixednesses2244852fixednesses
fondnesses1437702fondnesses
freenesses1339862freenesses
gonenesses11310252gonenesses
kindnesses1537212kindnesses
likenesses1449532likenesses
litenesses10513002litenesses
livenesses13411052livenesses
lonenesses10311342lonenesses
nicenesses12310332nicenesses
onenesses9311822_onenesses
pinknesses1636582pinknesses
rifenesses1339932rifenesses
ripenesses12310362ripenesses
sanenesses10412692sanenesses
tininesses10311152tininesses
vilenesses13310212vilenesses
widenesses1438772widenesses
wisenesses13310802wisenesses
agilenesses1247753agilenesses
airinesses102613603airinesses
aliennesses1145863aliennesses
alikenesses1547193alikenesses
alivenesses1448853alivenesses
alonenesses1147213alonenesses
barenesses12311693barenesses
basenesses12310553basenesses
biasnesses1236943biasnesses
bignesses1267953bi_gnesses
blindnesses1446183blindnesses
bluenesses1237923bluenesses
boninesses121111443boninesses
brininesses1338973brininesses
canonesses1238413canonesses
cutenesses12910873cutenesses
danknesses1536253danknesses
densenesses1247353densenesses
digeneses1147393digene_ses
dimnesses1238213di_mnesses
dinginesses1337473dinginesses
duenesses1039323_duenesses
dunnesses1037693dun_nesses
evennesses1345923evennesses
facilenesses1756703facilenesses
fadednesses16126563fadednesses
fairnesses1357383fairnesses
falsenesses1446743falsenesses
fancinesses1638143fancinesses
farnesses122310813f_arnesses
fastnesses1389073fastnesses
fatnesses121710463f_atnesses
fellnesses1346083fellnesses
fewnesses1534953f_ewnesses
feynesses1535223f_eynesses
ficklenesses2144133ficklenesses
fiercenesses1744293fiercenesses
fierinesses1439223fierinesses
filminesses1636233filminesses
finesse10187643fi__nesse_
finessed12136793fi__nessed
firstnesses1445733firstnesses
fishinesses17107233fishinesses
flatnesses1337763flatnesses
fleetnesses1445483fleetnesses
flintinesses1546323flintinesses
foulnesses1337923foulnesses
foxinesses20127723foxinesses
fozinesses22158183fozinesses
franknesses1845603franknesses
fullnesses1336193fullnesses
fulnesses1239033f_ulnesses
funkinesses18136993funkinesses
funninesses14106863funninesses
futilenesses1547173futilenesses
gamenesses1368983gamenesses
halenesses13312033halenesses
highnesses1746083highnesses
hipnesses1436753hi_pnesses
hugenesses1437133hugenesses
icinesses11310053_icinesses
idlenesses1138023idlenesses
iffinesses1635573iffinesses
illnesses937273_illnesses
inanenesses1149513inanenesses
ineptnesses1396383_ineptnesses
inertnesses1198713_inertnesses
ingresses1038533_ingresses
inkinesses1439413_inkinesses
innernesses1146733innernesses
invernesses1447023_invernesses
keennesses1445323keennesses
kinkinesses1435873kinkinesses
lamenesses12610563lamenesses
lanknesses1437503lanknesses
latenesses10413353latenesses
liminesses121310843liminesses
limpnesses14116653limpnesses
lionesses939423li_onesses
lithenesses1447303lithenesses
longnesses1138503longnesses
malenesses12312203malenesses
mildnesses1397393mildnesses
mindednesses16105383mindednesses
minutenesses1476163minutenesses
mirinesses121512303mirinesses
morenesses12811383morenesses
mutenesses1289933mutenesses
naivenesses1449083naivenesses
newnesses1236123__newnesses
nighnesses1446463nighnesses
nudenesses1157853nudenesses
oilinesses101512433oilinesses
opennesses1246313opennesses
palenesses12312653palenesses
pipinesses1448593pipinesses
pixinesses1937363pixinesses
planenesses1349033planenesses
primenesses1548973primenesses
pronenesses1379253pronenesses
puninesses121110743puninesses
purenesses12810723purenesses
raininesses11310473raininesses
ranknesses1438093ranknesses
rarenesses10313093rarenesses
richnesses1537793richnesses
riminesses121211403riminesses
rudenesses1188863rudenesses
safenesses1349373safenesses
sagenesses11510823sagenesses
samenesses12410853samenesses
shininesses1448293shininesses
sicknesses1636753sicknesses
sidednesses1347103sidednesses
singlenesses1346093singlenesses
sizinesses1938643sizinesses
snidenesses1248653snidenesses
solenesses10412703solenesses
sorenesses101313483sorenesses
spininesses1358453spininesses
supinenesses1445993supinenesses
surenesses101212203surenesses
tamenesses1259963tamenesses
tensenesses1147593tensenesses
thingnesses1545173thingnesses
thinnesses1346253thin_nesses
tidinesses1139213tidinesses
tinninesses1136863tinninesses
tirednesses1247733tirednesses
titanesses1037233titanesses
tritenesses11710353tritenesses
truenesses1039313truenesses
tweenesses1345803tweenesses
vainnesses1337343vain_nesses
waenesses1239773_waenesses
wannesses1239233wan_nesses
whininesses1746183whininesses
whitenesses1746633whitenesses
wildnesses14157363wildnesses
wilinesses131911083wilinesses
windinesses1557813windinesses
winepresses1643453winepresses
wirelesses1345333wirelesses
wirinesses131811513wirinesses
witnesses12219923wi_tnesses
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.1561145455.1
2DLD Change Limit1406031758.04617474.9
3Display Results1751750.0931881.7
 (SQL Overall)1786911758.29521542.0
 
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.