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

193 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
deafness123621(None) 
deadness1039231deadness
dearness939971dearness
daftness1235532d_aftness
deaconess1245542deaconess
deafens11317252deaf_ens
deafest112911512deaf_est
deafnesses1436222deafnesses
deepness1136442deepness
deftness1236302deftness
demoness1138052demoness
dewiness1238452dewiness
drabness1135802drabness
dwarfness1642792dwarfness
leafiness1236482leafiness
leafless11246572leafless
leanness837372leanness
meanness1037182meanness
nearness838312nearness
neatness839152neatness
realness8410442realness
selfness1135152selfness
weakness1535352weakness
adeptness1273953adeptness
awayness1443303awayness
badness1039573_badness
beadiness12249233beadiness
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
beefiness1435583beefiness
beefless1335493beefless
biasness1035813biasness
bleakness1543593bleakness
cheapness1643743cheapness
cleanness1144973cleanness
clearness1135633clearness
daffiness1634843daffiness
daftest11248943d_aftest
damners104112113d_amners
dampness1336073dampness
dankness13256693dankness
darkness13247343darkness
darnels83710433d_arnels
darners83815773d_arners
deadeners1146283deadeners
deadens93410693dea_dens
deadest93014883dea_dest
deadliness12115893deadliness
deadnesses1238943deadnesses
deafen10389673deaf_e_n
deafened1335853deafened
deafer104114813deaf_e_r
deafish1438533deaf_ish
dealers84118613dea_lers
deaned84620453dea_ne_d
deanery1137613dea_nery
deans66131393dea_n__s
dearest83618673dea_rest
dearies83526273dearie_s
dearnesses1139583dearnesses
deashes113313903deashe_s
deathless1335223deathless
deaves105319533dea_ve_s
deboners11268113deboners
debones103315113debone_s
debtless1135653debtless
decanes103118913decane_s
decayless1542863decayless
deedless10318253deedless
defacers14237993defacers
defaces133213403deface_s
defamers14258523defamers
defames132812253defame_s
defangs1235363defan_gs
defends12358773de_fends
defense1137503de_fense
defenses1237913de_fenses
defers105116943de_f_ers
deffest14308803de_ffest
defiers113913993de_fiers
defies104624053de_fie_s
definers124211193definers
defines114118683define_s
defleas1147223de_fleas
deftest112611713de_ftest
defuels11296983de_fuels
defuses114814593de_fuses
deifiers12348993deifiers
deifies113317453deifie_s
delaines9312963delaine_s
denes65639723de__ne_s
denseness1046863denseness
depones103717093depone_s
depress10239873de_press
detainees10267153detainees
detainers10269103detainers
dewless1137473de_wless
dimness1038843d_imness
direness9311303direness
doneness9411513doneness
dopiness11289973dopiness
dourness947683dourness
doziness18228553doziness
draftees12225253draftees
drafters12338523drafters
draftiness1444863draftiness
dragnets10136563dragnets
drainers92811253drainers
dreaminess1345313dreaminess
dreamless1243513dreamless
dreariness1146283dreariness
dryness11114783d_ryness
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunness8298983d_unness
earless74316073_earless
earners74016453_earners
earnest7318733_earnest
earnests837853_earnests
easiness8313043_easiness
edginess1036053edginess
eeriness8311873eeriness
farness102912203_farness
fatness103311293_fatness
fearless1137873fearless
fellness1135913fellness
fewness1335003fe_wness
feyness1334923fe_yness
flatness1138153flatness
gayness1136843_gayness
gearless937373gearless
gladness1036153gladness
grayness1235933grayness
greatness1036903greatness
halfness1435563halfness
harness102413933_harness
headiness132510363headiness
headless12289863headless
heatless113011463heatless
heaviness15207063heaviness
idealess935653idea_less
idealless1042953idealless
keenness1234883keenness
laxness1436043_laxness
leadless9248793leadless
leafiest113410883leafiest
leaflets11244813leaflets
leakiness1337503leakiness
leakless12246983leakless
leaners73718173lea_ners
leanest7415863lea_nest
learners8398153learners
lewdness1254173lewdness
madness10310073_madness
mealiness11310063mealiness
mealless10288363mealless
meaners94415243mea_ners
meanest9315703mea_nest
meatiness11311183meatiness
meatless103410863meatless
meekness1434303meekness
meetness1036653meetness
newness1035703ne_wness
ovalness1134673ovalness
patness92912283_patness
peakless14236683peakless
peartness1137773peartness
pertness10310093pertness
rawness1038153_rawness
readiness102611853readiness
reassess836513reassess
redness82012443re_dness
regalness1045473regalness
sadness8310613_sadness
safeness11239633_safeness
seaminess11310473seaminess
seamless10238723seamless
seatless83213003seatless
selfless1135013selfless
sexiness1537943sexiness
teariness9310633teariness
tearless848713tearless
waeness102512783_waeness
wanness102610683_wanness
weaners104613833wea_ners
weariness1238843weariness
wellness1135793wellness
wetness10277723we_tness
whatness1435093whatness
yearners11346373yearners

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.420425454.8
2DLD Change Limit1461621936.94021060.8
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.43624030.5
 
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.