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

102 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
plainness115518(None) 
painless10108342p_ainless
placidness1553302placidness
plainest10313612plai_nest
plainnesses1356202plainnesses
planeness1138152planeness
planless1036812pla_nless
planners10399932pla_nners
pliantness1263642pliantness
vainness1136062_vainness
alanines8314803alanine_s
algidness1144273algidness
alienness945373alienness
blackness1735663blackness
blandness1235973blandness
blankness1544673blankness
blindness1235343bl_indness
braininess1246123braininess
brainless1136403brainless
cleanness1144973cleanness
faintness1235833_faintness
fairness1136563_fairness
flakiness1636473flakiness
flannels1134843fla_nnels
flatness1138153fla_tness
fluidness1344293fluidness
frailness1236543frailness
gainless9117403_gainless
gladness1036153gla_dness
glariness1038553glariness
glaringness1343263glaringness
glaziness1935753glaziness
glibness1134143gl_ibness
gluiness937373glui_ness
graininess1145803graininess
grainless1035893grainless
laciness102112553_laciness
lameness102612673_lameness
lankness12237043_lankness
lanners73618333_la_nners
lateness82614073_lateness
laxness1436043_la_xness
laziness17239983_laziness
leanness837373_leanness
linnets739833_l_innets
lioness739103_l_ioness
lornness836493_lornness
meanness1037183mea_nness
packness1636933p_ackness
painters103013023p_ainters
paleness10312983p_aleness
pallidness1343283pallidness
panners93621273p_a_nners
pannes85522853p_a_nne_s
pastness102510503p_astness
patness92912283p_a_tness
peartness1137773peartness
phoniness1436303phoniness
pinkness1436513p__inkness
pinners93518603p__inners
pipiness1238003pipi_ness
pixiness1736093pixi_ness
placeless1335613placeless
plaices11411143plai_ce_s
plained103812233plai_ne_d
plainer93811983plai_ne_r
plains85019593plai_n__s
plaintext1863423plaintext
plaintexts1971343plaintexts
plaints94012053plai_n_ts
plaisters1137813plaisters
plaiters103512633plai_ters
planers94517943pla__ners
planes85028083pla__ne_s
planets93914083pla__nets
planned103810153pla_nne_d
planner93511623pla_nne_r
planters102915323pla_nters
platanes102711883platane_s
playless1334863pla_yless
pleasingness1552923pleasingness
plinkers14309393pl_inkers
plumbness1543133plumbness
plumpness1543473plumpness
plushness1444623plushness
pokiness14219863poki_ness
primness1276763p_rimness
princess12266803p_rincess
pulpiness1335603pulpi_ness
puniness101610273puni_ness
quaintness1943203quaintness
raininess949283_raininess
rainless8129703_rainless
slackness1535433slackness
slatiness92511363slatiness
slimness1036523sl_imness
staidness1037033staidness
stainless9176493stainless
thinness11277173_thinness
validness13125363validness
wanness102610683_wa_nness
zaniness1738663_zaniness

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411027.01621186.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.46923924.4
 
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.