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

192 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
dottiness105804(None) 
pottiness1179701pottiness
battiness11239842battiness
bittiness11228332bittiness
cattiness112310632cattiness
dirtiness1039472dirtiness
ditsiness1048142ditsiness
ditziness1945882ditziness
dodginess1235282dodginess
dopiness11289972do_piness
dorkiness14248052dorkiness
dottiest92611392dotti_est
dottinesses1238132dottinesses
dowdiness1485692dowdiness
downiness13106712downiness
doziness18228552do_ziness
dustiness102211032dustiness
fattiness12239372fattiness
goutiness1038762goutiness
jettiness1675692jettiness
knottiness1483592knottiness
loftiness1236572loftiness
nattiness9239332nattiness
nuttiness9207562nuttiness
pettiness1178702pettiness
rootiness979062rootiness
ruttiness9258792ruttiness
snottiness1055592snottiness
sootiness999832sootiness
spottiness1285762spottiness
tattiness9239412tattiness
wittiness12197222wittiness
antsiness937843antsiness
artiness81615403_artiness
artsiness937653artsiness
bogginess1335603bogginess
boniness102211803bo_niness
bonniness1136733bonniness
booziness20135613booziness
boskiness15196513boskiness
bossiness11257423bossiness
boxiness17247813bo_xiness
brattiness1255843brattiness
bustiness111810473bustiness
chattiness1565123chattiness
cockiness17248783cockiness
comfiness1646953comfiness
corkiness152810443corkiness
corniness112611183corniness
cosiness103214283co_siness
costliness1245993costliness
cottiers10399153cotti_ers
coziness19319823co_ziness
daffiness1634843daffiness
daftness1235533daft_ness
dailiness1038673dailiness
daintiness1145963daintiness
datedness1187753datedness
deftness1236303deft_ness
dentines93418403dentine_s
destines93619663destine_s
detainees10267153detainees
detainers10269103detainers
dewiness1238453d_ewiness
dinginess1137823dinginess
dippiness1435973dippiness
ditties83116983ditti_e_s
dizziness1834183dizziness
doctrines1247153doctrine_s
doltishness1544213doltishness
domaines11611063domaine_s
domines102918973do_mine_s
doneness9411513do_neness
dopeyness1543473dopeyness
dotiest83717453do_ti_est
dottels8327783dott__els
dotterels1043903dotterels
dotters83715973dott__ers
dottier83910923dotti_e_r
dotting93314483dottin__g
dottles83912283dott_le_s
dottrels963493dott_rels
doughtiness1642703doughtiness
dourines9311373dourine_s
dourness947683do_urness
draftiness1444863draftiness
drowsiness1443643drowsiness
dumpiness1435653dumpiness
duskiness14216683duskiness
emptiness1335373emptiness
foaminess1437503foaminess
fogginess1434973fogginess
forkiness16268703forkiness
foxiness18257403fo_xiness
foziness20257803fo_ziness
frostiness1336563frostiness
frothiness1645723frothiness
fustiness121910243fustiness
godliness1136593godliness
goofiness1365603goofiness
goriness9310753go_riness
grittiness1145163grittiness
gustiness10189893gustiness
gutsiness10226963gutsiness
hastiness122410883hastiness
heftiness1536313heftiness
hoariness1238823hoariness
hokiness152510183ho_kiness
holiness112512503ho_liness
hominess132712453ho_miness
horniness12309143horniness
horsiness12259473horsiness
hotlines11811643hotline_s
hotness1038613ho_t_ness
hotties103016963hotti_e_s
jokiness19227393jo_kiness
jolliness1636213jolliness
jottings16275193jottin_gs
jowliness1934853jowliness
kookiness1235563kookiness
loaminess1137493loaminess
loathness1244703loathness
loginess9310163lo_giness
looniness9137573looniness
loopiness11136543loopiness
lostness837683lost_ness
lousiness9219033lousiness
lowliness1236403lowliness
lustiness92010453lustiness
maltiness112910573maltiness
matiness102114753_matiness
meatiness11311183meatiness
mistiness111911633mistiness
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mootness1036753moot_ness
mopiness12259063mo_piness
mossiness11258323mossiness
mousiness11219023mousiness
mustiness112211663mustiness
nastiness92310573nastiness
niftiness1236363niftiness
noisiness948343noisiness
nosiness83211393no_siness
notedness1047323notedness
oiliness8311563_oiliness
ooziness17237513_ooziness
pastiness112312353pastiness
pithiness1437563pithiness
pokiness14219863po_kiness
porkiness15249193porkiness
portliness1246833portliness
potlines10714213potline_s
potties93723543potti_e_s
pottiest102815973potti_est
pottinesses1339103pottinesses
poutines102415103poutine_s
prettiness1257393prettiness
ritziness1835823ritziness
rockiness15237833rockiness
roominess1157303roominess
ropiness102311073ro_piness
rosiness82613173ro_siness
rottenest949603rottenest
rottenness1043763rottenness
routines82214363routine_s
rowdiness1396233rowdiness
runtiness92410393runtiness
rustiness92111933rustiness
saltiness93312113saltiness
slatiness92511363slatiness
smuttiness1244403smuttiness
snootiness1085833snootiness
soapiness1138293soapiness
softness1136433soft_ness
sogginess1136183sogginess
soppiness1336543soppiness
sorriness939583sorriness
sottishness1444433sottishness
sportiness1278233sportiness
stoniness938343stoniness
tartiness92112053tartiness
tastiness92311143tastiness
testiness9209753testiness
tontines82114733tontine_s
woodiness13147873woodiness
wooliness12147693wooliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
worthiness1645913worthiness

Search took 8 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.403443402.0
2DLD Change Limit1486411927.05021083.8
3Display Results1921920.0932064.5
 (SQL Overall)1786911927.54623680.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.