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

134 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
planeness113816(None) 
aloneness957312aloneness
blandness1235972blandness
blankness1544672blankness
inaneness948382inaneness
lameness102612672_lameness
lankness12237042_lankness
lateness82614072_lateness
loneness8512092_loneness
paleness10312992p_aleness
paneless102611772p_aneless
placeless1335612placeless
plainness1155202plainness
planenesses1349032planenesses
planless1036832plan_less
planners10399942plan_ners
pliantness1263652pliantness
proneness11310452proneness
saneness82313722_saneness
alanines8314803alanine_s
alienness945373alienness
alikeness1336333alikeness
aliveness1238223aliveness
awareness1236343awareness
bareness10912813_bareness
baseness10910943_baseness
blackness1735663blackness
bladeless1234303bladeless
blameless1334733blameless
blindness1235343blindness
blondness1234963blondness
blueness1038213bl_ueness
bluntness1144343bluntness
braveness14237763braveness
canoness1039393_canoness
cleanness1144973clean_ness
closeness1137613closeness
dankness13256693_dankness
doneness9411513_doneness
elatedness1146033elatedness
falseness1236093falseness
fineness11310653_fineness
flakiness1636473flakiness
flameless1435353flameless
flannels1134843flan_nels
flatness1138153fla_tness
frankness1655223frankness
gameness112810693_gameness
gladness1036153gla_dness
glandless1134163glandless
glariness1038553glariness
glaziness1935753glaziness
goneness9310763_goneness
grandness1138303grandness
graveness13288383graveness
haleness11312623_haleness
humaneness1544023humaneness
insaneness1046493insaneness
irateness9310493irateness
laceless10239853_laceless
laciness102112553_laciness
landless94011173_landless
lankiness1338053_lankiness
lanners73618333_lan_ners
largeness1038273_largeness
laxness1436043_la_xness
laziness17239983_laziness
leanness837373lean_ness
likeness12229863_likeness
lineless82711943_lineless
liteness82213213_liteness
liveness112411393_liveness
longness938553_longness
maleness10312313_maleness
maneless102812343_maneless
meanness1037183mean_ness
oblateness1244893oblateness
oneness7512143__oneness
packness1636933p_ackness
pangenes112612833p_angene_s
pangeneses1346373p_angeneses
pangenesis1345813p_angenesis
panners93621273p_an_ners
pannes85522853p_an_ne_s
pastness102510503p_astness
patness92912283p_a_tness
peakedness1744863peakedness
peartness1137773peartness
phoniness1436303phoniness
pinenes93416693p_inene_s
pinkness1436513p_inkness
placentas1364833placentas
placidness1553303placidness
plainest10313623pla_inest
planches153111873planche_s
planchets16236753planchets
planers94517953pla__ners
planes85028083pla__ne_s
planets93914083pla__nets
plankters1544583plankters
planlessness1444993planlessness
planned103810153plan_ne_d
planner93511633plan_ne_r
planters102915333plan_ters
plantlets1145033plantlets
platanes102711883platane_s
platelets1165763platelets
platens94213983platen__s
playless1334863pla_yless
pliableness1546613pliableness
plumbness1543133plumbness
plumpness1543473plumpness
plushness1444623plushness
politeness1247983politeness
primeness1338663primeness
profaneness1653593profaneness
puniness101610273p_uniness
pureness101110183p_ureness
rankness12267943_rankness
rareness81112853_rareness
safeness11239633_safeness
sageness92111983_sageness
sameness102712683_sameness
scantness1135733scantness
slackness1535433slackness
slanginess1146273slanginess
slatiness92511363slatiness
spareness1139863spareness
staleness9310783staleness
suaveness1247703suaveness
tameness102411253_tameness
waeness102512783_wa_eness
wanness102610683_wan_ness
zaniness1738663_zaniness

Search took 9 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 Limit1486411347.81319024.8
3Display Results1341340.0632127.0
 (SQL Overall)1786911348.29921531.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.