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

184 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
deftness123630(None) 
daftness1235531daftness
adeptness1273952adeptness
deadness1039232deadness
deafness1236212deafness
dearness939972dearness
debtless1135652debtless
deepness1136442deepness
defenses1237912defenses
definers124211192definers
defines114118682define_s
deftest112611712deft_est
deftnesses1436812deftnesses
demoness1138052demoness
dewiness1238452dewiness
heftiness1536312heftiness
meetness1036652meetness
neatness839152neatness
pertness10310092pertness
softness1136432softness
wetness10277722we_tness
adultness1043973adultness
alertness946053alertness
aptness9268573_aptness
beatless103311593beatless
beefiness1435583beefiness
beltless10297713beltless
centners1057243centners
curtness1037263curtness
daffiness1634843daffiness
daftest11248943daft_est
daftnesses1436383daftnesses
dampness1336073dampness
dankness13256693dankness
darkness13247343darkness
deaconess1245543deaconess
deathless1335223deathless
deboners11268113deboners
debones103315113debone_s
decanes103118913decane_s
deedless10318253deedless
defacers14237993defacers
defaces133213403deface_s
defamers14258523defamers
defames132812253defame_s
defangs1235363defan_gs
defences1439633defences
defenders1436363defenders
defends12358773defen_ds
defense1137503defen_se
defensed1336223defensed
defers105116943def__ers
deffest14308803def_fest
defiers113913993def_iers
defies104624053def_ie_s
defilers12439473defilers
defiles114016843defile_s
define104718143define__
defined123813823define_d
definer114413773define_r
definiens1345303definiens
defleas1147223def_leas
deforest1238793deforest
deforests1344373deforests
defter104215923deft_e_r
defuels11296983def_uels
defunds12376753defun_ds
defusers12487363defusers
defuses114814593defuse_s
defuzes20398303defuze_s
deities82621923deitie_s
denes65639723de__ne_s
denseness1046863denseness
dentines93418403dentine_s
depones103717093depone_s
depress10239873de_press
depthless1542753depthless
destines93619663destine_s
detents83615153de_tents
deters74724683de_t_ers
detest74122843de_t_est
detests83711743de_t_ests
devoutness1443103devoutness
dewless1137473de_wless
dimness1038843d_imness
directness1344193directness
direness9311303direness
dirtiness1039473dirtiness
distress9311713distress
doneness9411513doneness
dopiness11289973dopiness
dottiness1058043dottiness
dourness947683dourness
doziness18228553doziness
drabness1135803drabness
draftiness1444863draftiness
dryness11114783d_ryness
ductless11196313ductless
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunness8298983d_unness
dustiness102211033dustiness
dustless9328353dustless
edginess1036053edginess
editress944933editress
eeriness8311873eeriness
erectness1146123erectness
fastness11238763fastness
fatness103311293_fatness
feetless1137383feetless
fellness1135913fellness
fewness1335003fe_wness
feyness1334923fe_yness
fitness10299393_fitness
flatness1138153flatness
fleetness1244753fleetness
gastness9278473gastness
giftless1245173giftless
greatness1036903greatness
heatless113011463heatless
hefters134312003heft_ers
heftiest1439183heftiest
hotness1038613_hotness
iffiness1435023iffiness
ineptness1145073ineptness
inertness947973inertness
jettiness1675693jettiness
justness1535323justness
keenness1234883keenness
leafiness1236483leafiness
leanness837373leanness
leftest10269463left_est
lefties10312073leftie_s
lewdness1254173lewdness
loftiness1236573loftiness
loftless1135903loftless
lostness837683lostness
meanness1037183meanness
meatiness11311183meatiness
meatless103410863meatless
meekness1434303meekness
mootness1036753mootness
nearness838313nearness
netless739863ne_tless
newness1035703ne_wness
niftiness1236363niftiness
overtness1238223overtness
pastness102510503pastness
patness92912283_patness
peartness1137773peartness
peltless10267373peltless
pettiness1178703pettiness
raptness1046733raptness
realness8410443realness
redness82012443re_dness
refiners114713313refiners
refines105426343refine_s
restless82713163restless
restress82511773restress
rifeness1138583rifeness
riftless1136943riftless
safeness11239633safeness
saltness82610243saltness
seatless83213003seatless
selfness1135153selfness
sexiness1537943sexiness
sweetness1245683sweetness
swiftness1543653swiftness
tartness82210133tartness
tautness8217183tautness
tentless8229843tentless
testiness9209753testiness
textless15245793textless
unfitness1244843unfitness
vastness11257293vastness
ventless11249053ventless
vestless11258843vestless
weakness1535353weakness
wellness1135793wellness
whatness1435093whatness
witness103010013_witness
zestless17247433zestless

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.406440125.6
2DLD Change Limit1461621847.22020244.0
3Display Results1841840.0762421.1
 (SQL Overall)1786911847.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.