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

200 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
daftness123553(None) 
deftness1236301deftness
aptness9268572_aptness
daffiness1634842daffiness
daftest11248942daft_est
daftnesses1436382daftnesses
dampness1336072dampness
dankness13256692dankness
darkness13247342darkness
deafness1236212deaf_ness
draftiness1444862draftiness
fastness11238762fastness
fatness103311292fa_tness
gastness9278472gastness
pastness102510502pastness
patness92912282pa_tness
raptness1046732raptness
safeness11239632safeness
saltness82610242saltness
softness1136432softness
tartness82210132tartness
tautness8217182tautness
vastness11257292vastness
actress948533_actress
adeptness1273953adeptness
adultness1043973adultness
afters94717073_aft_ers
apartness1146053apartness
artiness81615403_artiness
artless73712513_artless
badness1039573ba_dness
baldness1137043baldness
bareness10912813bareness
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
battiness11239843battiness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
cattiness112310633cattiness
craftiness1545753craftiness
curtness1037263curtness
daffiest1537843daffiest
dafter104813343daft_e_r
dailiness1038673dailiness
dailyness1343643dailyness
daintiness1145963daintiness
damners104112113da_mners
daphnes13327683daphne_s
darnels83710433da_rnels
darners83815773da_rners
darters84017603dart_ers
dartles84014133dartle_s
datedness1187753datedness
dateless9259963dateless
daters74827373da_t_ers
dates65639153da_t_e_s
daunters9329853daunters
dauntless1033663dauntless
dauties83315763dautie_s
dawties113312703dawtie_s
dazedness20114963dazedness
deaconess1245543deaconess
deadness1039233deadness
dearness939973dearness
debtless1135653debtless
deepness1136443deepness
defenses1237913defenses
definers124211193definers
defines114118683define_s
deftest112611713deft_est
deftnesses1436813deftnesses
demoness1138053demoness
dewiness1238453dewiness
dimness1038843d_imness
direness9311303direness
dirtiness1039473dirtiness
distress9311713distress
doneness9411513doneness
dopiness11289973dopiness
dottiness1058043dottiness
dourness947683dourness
doziness18228553doziness
drabness1135803drabness
draftees12225253draft_ees
drafters12338523draft_ers
draftiest1335943draftiest
dryness11114783d_ryness
ductless11196313ductless
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunness8298983d_unness
dustiness102211033dustiness
dustless9328353dustless
dwarfness1642793dwarfness
easiness8313043easiness
exactness1843623exactness
faintness1235833faintness
fairness1136563fairness
farness102912203fa_rness
fatless103212203fa_tless
fattiness12239373fattiness
fitness10299393_fitness
flatness1138153flatness
gameness112810693gameness
gaminess112911063gaminess
gauntness1044203gauntness
gayness1136843ga_yness
giftless1245173giftless
hafters134614333haft_ers
haleness11312623haleness
halfness1435563halfness
haltless11308443haltless
hardness122411083hardness
harness102413933ha_rness
hastiness122410883hastiness
hatless103813443ha_tless
haziness20248513haziness
heftiness1536313heftiness
hotness1038613_hotness
iffiness1435023iffiness
inaptness1144333inaptness
justness1535323justness
laciness102112553laciness
lameness102612673lameness
lankness12237043lankness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
leafiness1236483leafiness
loftiness1236573loftiness
loftless1135903loftless
lostness837683lostness
madness10310073ma_dness
maleness10312313maleness
maltiness112910573maltiness
mastless102610023mastless
matiness102114753matiness
matless93014043ma_tless
mattress1036533mattress
maziness19239543maziness
meetness1036653meetness
mootness1036753mootness
nastiness92310573nastiness
nattiness9239333nattiness
neatness839153neatness
niftiness1236363niftiness
packness1636933packness
paleness10312983paleness
partners102711133partners
pastiness112312353pastiness
pastless102411203pastless
peartness1137773peartness
pertness10310093pertness
raciness102413453raciness
rafters103715633raft_ers
rankness12267943rankness
rareness81112853rareness
rashness1138093rashness
rawness1038153ra_wness
rifeness1138583rifeness
riftless1136943riftless
sadness8310613sa_dness
sageness92111983sageness
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
scantness1135733scantness
smartness1136143smartness
swartness1236113swartness
swiftness1543653swiftness
tacitness1134873tacitness
tactless10288463tactless
tallness837103tallness
tameness102411253tameness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
unaptness1154173unaptness
unfitness1244843unfitness
vainness1136063vainness
waeness102512783wa_eness
wafters134112813waft_ers
waitress1135223waitress
wanness102610683wa_nness
wariness11313213wariness
warmness1337063warmness
wartless11279923wartless
wattless11268723wattless
waviness1437723waviness
waxiness1836723waxiness
wetness10277723_wetness
whatness1435093whatness
witness103010013_witness
zaniness1738663zaniness

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622007.17320376.7
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.70223200.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.