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

129 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
blindness123534(None) 
blandness1235971blandness
blondness1234961blondness
blankness1544672blankness
blinders113911142blind_ers
blindest11609092blind_est
blindnesses1446182blindnesses
bluntness1144342bluntness
boundness1235942boundness
brininess1138202brininess
kindness13236652_kindness
acidness1136723aci_dness
algidness1144273algidness
alienness945373alienness
alikeness1336333alikeness
aliveness1238223aliveness
aloneness957313aloneness
aridness939223ari_dness
avidness1246113avi_dness
badness1039573b__adness
baldness1137043b_aldness
bandiness122310243b_andiness
biasness1035813b_iasness
bigness1038193b_i_gness
binders103920743b_ind_ers
bindles104016453b_indle_s
blackness1735663blackness
blandest113811043bland_est
blandnesses1446623blandnesses
bleakness1543593bleakness
blenders115210993blend_ers
blendes104713683blend_e_s
blindages1343663blindages
blinded114810023blind_e_d
blinder103912983blind_e_r
blindfish1842763blindfish
blindguts1341453blindguts
blinds95111613blind___s
blinkers14388503blin_kers
blintzes1944263blintze_s
blissless1142633blissless
blondes104213163blond_e_s
blondest11419243blond_est
blondines1246153blondine_s
blondnesses1445543blondnesses
bloodiness1344353bloodiness
bloodless1234513bloodless
blowiness1435623blowiness
blueness1038213bl_ueness
bluffness1742503bluffness
bluishness1544593bluishness
blunders113911343blund_ers
boldness1136973b_oldness
bondless1148813b_ondless
boniness102211803b_oniness
bonniness1136733bonniness
boringness1344673boringness
boundless1235183boundless
braininess1246123braininess
brandless1236123brandless
briefness1444113briefness
brindles113710223brindle_s
brineless1136243brineless
briskness1544763briskness
broadness1256663broadness
faintness1235833faintness
fineness11310643_fineness
flinders12439263flind_ers
flintiness1345893flintiness
fluidness1344293fluidness
fondness1237213_fondness
gelidness1144473geli_dness
gladness1036153gl_adness
glandless1134163glandless
glibness1134133gli_bness
grandness1138303grandness
kindless13289243_kindless
landless94011173_landless
lankness12237043_lankness
lewdness1254173_lewdness
lidless8309273_li_dless
likeness12229863_likeness
liminess10510643_liminess
limpness1246703_limpness
lindanes939173_lindane_s
lindens839413_lind_ens
lindies8416583_lindie_s
lineless82711943_lineless
linnets739833_lin_nets
lintless82710013_lintless
lioness739103_li_oness
liteness82213213_liteness
liveness112411393_liveness
lividness1344713_lividness
loneness8512093_loneness
longness938553_longness
loudness937013_loudness
mildness1136523_mildness
mindless11319443_mindless
oldness836403ol__dness
pinkness1436513_pinkness
plainness1155183plain_ness
planeness1138153planeness
pliantness1263643pliantness
purblindness175853purblindness
raininess949273raininess
rindless92510193_rindless
roundness1047013roundness
shininess1237333shininess
slickness1535903slickness
sliminess1137423sliminess
slimness1036523sli_mness
slinkiness1445153slinkiness
slipdress1242433slipdress
solidness1036903soli_dness
soundness1036963soundness
spininess1137963spininess
thingness1354893thingness
thinness11277163thin_ness
tininess8310633_tininess
unkindness1544133unkindness
vainness1136063vain_ness
validness13125363vali_dness
voidness1235553voi_dness
weirdness1343593weirdness
whininess1535123whininess
wildness1236203_wildness
windiness1337373_windiness
windless123310863_windless

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.406440125.6
2DLD Change Limit1486411296.12324275.8
3Display Results1291290.0632047.6
 (SQL Overall)1786911296.59227107.3
 
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.