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 “electiveness” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
electiveness175755(None) 
selectiveness1856511selectiveness
defectiveness2256542defectiveness
effectiveness2455672effectiveness
electivenesses1957642electivenesses
reflectiveness2255102reflectiveness
activeness1547703__activeness
creativeness1747763creativeness
deceptiveness2155693deceptiveness
electioneers1453693electioneers
electives1448933electiv__e_s
elusiveness1466603el_usiveness
evocativeness2154183evocativeness
festiveness1748223_festiveness
fictiveness1946313_fictiveness
invectiveness2156733invectiveness
objectiveness2755163objectiveness
perfectiveness2455343perfectiveness
reactiveness1756923reactiveness
receptiveness2056123receptiveness
reductiveness1955543reductiveness
respectiveness2155363respectiveness
restiveness1449663_restiveness
retentiveness1657163retentiveness
seductiveness1955243seductiveness
selectivenesses2056003selectivenesses
abortiveness1755324abortiveness
adaptiveness1853644adaptiveness
aliveness1238224al___iveness
allusiveness1554404allusiveness
amativeness1646224_amativeness
assertiveness1655504assertiveness
attentiveness1665154attentiveness
aversiveness1896234aversiveness
coerciveness1955404coerciveness
costiveness1648214_costiveness
decisiveness1855924_decisiveness
defectivenesses2496074defectivenesses
defensiveness20115814defensiveness
delusiveness1655754del_usiveness
effectivenesses2665104effectivenesses
effusiveness2154934effusiveness
ejectives2145444ejectiv__e_s
electees10238724elect__e_e_s
electioneer1353864electi_oneer
elections112414974electi_on__s
elective13311004electiv__e__
electively1846384electiv__ely
electress1146114elect___ress
electresses1345964elect_resses
electrogeneses1764524electrogeneses
electrogenesis1764474electrogenesis
electroless1356004elect_roless
elevenses1244334ele___venses
entireness1048364__entireness
erectness1146124erect___ness
erosiveness1447584e_rosiveness
evasiveness1755744e_vasiveness
exactingness2252124exactingness
excessiveness2554964excessiveness
expensiveness2555584expensiveness
extensiveness2355304extensiveness
fertileness1447574_fertileness
fleetingness1652654fleetingness
fugitiveness1964024fugitiveness
furtiveness1746534_furtiveness
illusiveness1555234illusiveness
ineffectiveness2683004ineffectiveness
inventiveness1956974inventiveness
liveness112411394_l___iveness
lucrativeness1854574_lucrativeness
nativeness1357834__nativeness
negativeness1656084negativeness
operativeness1876664operativeness
pensiveness1648654_pensiveness
perceptiveness2354784perceptiveness
petiteness1248494_pe_titeness
plaintiveness1854084plaintiveness
positiveness1756494positiveness
preciseness1545784prec_iseness
preventiveness2294894preventiveness
protectiveness2154594protectiveness
punitiveness1755364punitiveness
recessiveness1865904recessiveness
reflexiveness2662744refle_xiveness
refractiveness2254854refractiveness
repetitiveness1963844repetitiveness
resistiveness1656024resistiveness
secretiveness1865864secretiveness
selectness1245454select___ness
sensitiveness1655814sensitiveness
sportiveness1766984sportiveness
subjectiveness2863974subjectiveness
talkativeness2053004talkativeness
tentativeness1655024tentativeness
vegetativeness2173254vegetativeness
votiveness1646354__votiveness

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 Filter1786911247900.393454684.5
2DLD Change Limit124790976.64018793.7
3Display Results97970.0631539.7
 (SQL Overall)178691977.09625181.9
 
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.