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

247 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
vastness1125729(None) 
fastness11238761fastness
gastness9278471gastness
pastness102510501pastness
aptness9268572_aptness
baseness10910942baseness
bassness1096742bassness
daftness1235532daftness
easiness8313042easiness
fatness103311292fa_tness
hastiness122410882hastiness
justness1535322justness
lostness837682lostness
mastless102610022mastless
nastiness92310572nastiness
pastiness112312352pastiness
pastless102411202pastless
patness92912282pa_tness
raptness1046732raptness
rashness1138092rashness
saltness82610242saltness
tartness82210132tartness
tastiness92311142tastiness
tautness8217182tautness
vainness1136062vainness
vastest102911512vast_est
vastiest112713072vastiest
vastnesses13128202vastnesses
vestless11258842vestless
actress948533_actress
apartness1146053apartness
artiness81615403_artiness
artless73712513_artless
ashiness1138963_ashiness
ashless10318453_ashless
assess65710463_as_sess
asters65631603_ast_ers
avidness1246113avidness
badness1039573ba_dness
baldness1137043baldness
bareness10912813bareness
baroness101210063baroness
baseless1099563baseless
basinets1039063basinets
basters94930303bast_ers
bastes85330383bast_e_s
battiness11239843battiness
biasness1035813bias_ness
brashness1436323brashness
business102110693business
bustiness111810473bustiness
busyness13264813busyness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
cashless1336773cashless
castanets1146333castanets
casters94729903cast_ers
castes85631863cast_e_s
castles94917733castle_s
cattiness112310633cattiness
chasteness1546523chasteness
cosiness103214283cosiness
costless10310003costless
crassness1136213crassness
curtness1037263curtness
dampness1336073dampness
dankness13256693dankness
darkness13247343darkness
deftness1236303deftness
distress9311713distress
dustiness102211033dustiness
dustless9328353dustless
easters75125683east_ers
exactness1843623exactness
faintness1235833faintness
fairness1136563fairness
falseness1236093falseness
farness102912203fa_rness
fasteners12237053fasteners
fastens105511753fast_ens
fastest102413723fast_est
fastnesses1389083fastnesses
fatless103212203fa_tless
fattiness12239373fattiness
feastless1235043feastless
firstness1245013firstness
fitness10299393_fitness
flatness1138153flatness
fustiness121910243fustiness
gameness112810693gameness
gaminess112911063gaminess
gasless8319013gas_less
gassiness10268313gassiness
gasters85624293gast_ers
gastnesses11129143gastnesses
gastreas957263gastreas
gauntness1044203gauntness
gayness1136843ga_yness
gustiness10189893gustiness
gustless9287683gustless
haleness11312623haleness
halfness1435563halfness
haltless11308443haltless
hardness122411083hardness
harness102413933ha_rness
harshness1545963harshness
hasteners12267813hasteners
hastens106214813hast_ens
hastes95727073hast_e_s
hastiest112916503hastiest
hatless103813443ha_tless
haziness20248513haziness
hostess103210243host_ess
hotness1038613_hotness
inaptness1144333inaptness
laciness102112553laciness
lameness102612673lameness
lankness12237043lankness
lasters75627693last_ers
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
listless8269263listless
lushness1136233lushness
lustiness92010453lustiness
madness10310073ma_dness
maleness10312313maleness
maltiness112910573maltiness
massiness112810143massiness
massless10277113massless
masters94628923mast_ers
matiness102114753matiness
matless93014043ma_tless
mattress1036533mattress
maziness19239543maziness
meetness1036653meetness
mistiness111911633mistiness
mistress10310703mistress
moistness1146343moistness
mootness1036753mootness
mustiness112211663mustiness
nasties73520493nastie_s
nastiest83615953nastiest
nattiness9239333nattiness
neatness839153neatness
nosiness83211393nosiness
ovalness1134673ova_lness
overtness1238223overtness
packness1636933packness
paleness10312983paleness
partners102711133partners
passless10247223passless
pastels95215183past_els
pasters94531733past_ers
pastes85233913past_e_s
pasties94529813pastie_s
pastiest103319553pastiest
pastises103616053pastises
pastnesses12910513pastnesses
peartness1137773peartness
pertness10310093pertness
poshness1356653poshness
raciness102413453raciness
rankness12267943rankness
rareness81112853rareness
raspiness1137303raspiness
rasters74629023rast_ers
rawness1038153ra_wness
restless82713163restless
restress82511773restress
rosiness82613173rosiness
rustiness92111933rustiness
rustless83510243rustless
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
sashless1136603sashless
sassiness8249333sassiness
scantness1135733scantness
smartness1136143smartness
softness1136433softness
stress66616673__stress
swartness1236113swartness
tacitness1134873tacitness
tactless10288463tactless
tallness837103tallness
tameness102411253tameness
tartiness92112053tartiness
tasteless935673tasteless
tasters74225643tast_ers
tastes64126423tast_e_s
tastiest83216633tastiest
tattiness9239413tattiness
testiness9209753testiness
unaptness1154173unaptness
unstress837373unstress
vacantness1562513vacantness
vagueness1343933vagueness
vahines133410523vahine_s
vainest10315763va_inest
validness13125363validness
valines104520213valine_s
vanes85130973va__ne_s
vanners103612843va_nners
vapidness15144423vapidness
vases84626263vas__e_s
vaster94521023vast_e_r
vastier103613203vastie_r
vasts86423773vast___s
vaunters11327753vaunters
ventless11249053ventless
vestees103513173vest_ees
victress1344523victress
vileness1139983vileness
vintners1134573vintners
vistaless1254573vistaless
voidness1235553voidness
votress1035483v_otress
waeness102512783wa_eness
waistless1235093waistless
waitress1135223waitress
wanness102610683wa_nness
wariness11313213wariness
warmness1337063warmness
wartless11279923wartless
washiness1537043washiness
waspiness1435793waspiness
wasters104026593wast_ers
wastes96224883wast_e_s
wastrels1136203wastrels
wattless11268723wattless
waviness1437723waviness
waxiness1836723waxiness
wetness10277723_wetness
whatness1435093whatness
wiseness112010753wiseness
witness103010013_witness
yeastiness1344883yeastiness
yeastless1234053yeastless
zaniness1738663zaniness
zestless17247433zestless

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622476.34323043.0
3Display Results2472470.1102245.5
 (SQL Overall)1786912476.87625987.6
 
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.