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

211 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
campiness153754(None) 
bumpiness1535282bumpiness
caginess11310302ca_giness
cakiness1449552ca_kiness
camphines1847562camphine_s
campiest142212142campi_est
campinesses1737112campinesses
campings154010202campin_gs
canniness1138642canniness
cattiness112310632cattiness
clamminess1643612clamminess
comfiness1646952comfiness
dampness1336072damp_ness
dumpiness1435652dumpiness
gaminess112911062gam_iness
hamminess1635712hamminess
happiness1636002happiness
humpiness1635772humpiness
jumpiness2034292jumpiness
lumpiness1336482lumpiness
nappiness1335232nappiness
raspiness1137302raspiness
sappiness1337442sappiness
swampiness1773352swampiness
waspiness1435792waspiness
wimpiness1635292wimpiness
achiness1339703_achiness
airiness8412213_airiness
alpines94016193_alpine_s
amines84727983_am_ine_s
ammines11312673_ammine_s
ampleness1345303_ampleness
aptness9268573_a_ptness
artiness81615403_artiness
ashiness1138963_ashiness
bagginess1355953bagginess
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
battiness11239843battiness
bawdiness15235543bawdiness
cabinets1238283ca_binets
cageyness1543483cageyness
calcines12314753calcine_s
calmness1236643ca_lmness
camises114218463cam_ise_s
cammies134016483cammi_e_s
campaigners1851873campaigners
campers134220293camp__ers
campfires1844123campfire_s
camphenes1846463camphenes
camphine1738373camphine__
camphires1845783camphire_s
campier133313273campi_e_r
camping143118973campin__g
campions143511293campi_ons
campongs15356123campon_gs
camporees1546103camporees
campsites1546473campsite_s
campuses1437773campuse_s
candidness1444773candidness
canines93724033ca_nine_s
canoness1039393ca_noness
capiases1239253ca_piases
capizes20410373ca_pize_s
capless114312763ca_p_less
cappings15369493cappin_gs
carbines123617543carbine_s
carlines103521653carline_s
carmines123617873carmine_s
carpings133812393carpin_gs
cassines103116613cassine_s
chanciness1745123chanciness
chariness14310063chariness
chattiness1565123chattiness
chewiness1744823chewiness
chopines152711733chopine_s
choppiness1973563choppiness
chumminess1943113chumminess
classiness12196313classiness
clumsiness1444333clumsiness
cockiness17248783cockiness
combineds16255283combineds
combiners15247943combiners
combines142814623combine_s
comeliness1446993comeliness
compilers1537053compilers
compiles14311983compile_s
complines15312833compline_s
compress1439053comp_ress
corkiness152810443corkiness
corniness112611183corniness
cosiness103214283c_osiness
coziness19319823c_oziness
craftiness1545753craftiness
cragginess1444143cragginess
crampiest15268623crampi_est
crankiness1636173crankiness
craziness2037383craziness
creaminess1446203cream_iness
creepiness1444883creepiness
crispiness1444793crispiness
crumminess1643693crumminess
curliness1138553curliness
cushiness14197183cushiness
daffiness1634843daffiness
dailiness1038673dailiness
dampeners1444663dampeners
dampings14377523dampin_gs
dippiness1435973dippiness
dopiness11289973_dopiness
earliness939693earliness
easiness8313043ea_siness
emptiness1335373_emptiness
famines123216263fam_ine_s
fanciness1437673fanciness
fattiness12239373fattiness
foaminess1437503foam_iness
gabbiness1434403gabbiness
gameness112810693gam_eness
gamines103618463gam_ine_s
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
gawkiness1734753gawkiness
gemminess1464643gemminess
grapiness1238253grapiness
grumpiness1543273grumpiness
gumminess1454973gumminess
hairiness1238013hairiness
handiness132110933handiness
hardiness132310363hardiness
hastiness122410883hastiness
haziness20248513ha_ziness
hippiness1635463hippiness
hominess132712453hom_iness
jazziness2432843jazziness
laciness102112553la_ciness
lameness102612673lam_eness
lankiness1338053lankiness
larkiness1338113larkiness
laziness17239983la_ziness
liminess10510643lim_iness
limpidness1543083limpidness
limpness1246703limp_ness
lippiness1335413lippiness
loaminess1137493loam_iness
loopiness11136543loopiness
maltiness112910573maltiness
manginess122010413manginess
manliness111310123manliness
massiness112810143massiness
matiness102114753ma_tiness
maziness19239543ma_ziness
mopiness12259063_mopiness
nastiness92310573nastiness
nattiness9239333nattiness
nippiness1334713nippiness
pastiness112312353pastiness
pawkiness1835443pawkiness
peppiness1235183peppiness
pipiness1238003_pipiness
pulpiness1335603pulpiness
raciness102413453ra_ciness
raininess949273raininess
rampikes1635393rampike_s
randiness102511443randiness
ranginess101610213ranginess
rapidness12155473ra_pidness
rapines95120863ra_pine_s
raptness1046733ra_ptness
riminess10510093rim_iness
ropiness102311073_ropiness
saltiness93312113saltiness
sameness102712683sam_eness
sandiness102111713sandiness
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scaliness1149303sca_liness
scampies1439333scampi_e_s
scantiness1236883scantiness
scariness11310183sca_riness
scrappiness1752293scrappiness
seaminess11310473seam_iness
skimpiness1842863skimpiness
snappiness1443833snappiness
soapiness1138293soapiness
soppiness1336543soppiness
tackiness1557693tackiness
talkiness1356913talkiness
tameness102411253tam_eness
tanginess10239283tanginess
tardiness10229923tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
vampiest15237653vampi_est
vampires15226033vampire_s
vapidness15144423va_pidness
wackiness1836523wackiness
wariness11313213wa_riness
washiness1537043washiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weepiness14215963weepiness
wispiness1435633wispiness
yumminess1653643yumminess
zaniness1738663za_niness

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 Filter1786911486410.420425454.8
2DLD Change Limit1486412116.36023371.2
3Display Results2112110.1101918.2
 (SQL Overall)1786912116.89025934.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.