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

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

54 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
nonexecutives256172(None) 
nonexecutive2452871nonexecutive_
executives2263163___executives
nonelective1666853nonelec_tive_
connectives1847504con_nec_tives
consecutive1855944con_secutive_
executive2164744___executive_
noneffective2363584noneffec_tive_
nonelections1456394nonelec_tions
nonexclusive2461844nonexclusive_
nonrelatives1564204non_relatives
nonselective1755414nonselec_tive_
coexecutors2261695co_execut_ors
collectives1846035co_llec_tives
conjunctives2653495conjunc_tives
connective1749255con_nec_tive_
consecutions1647045con_secutions
consecutively2383245con_secutively
convective2049115con_vec_tive_
correctives1845575co_rrec_tives
defectives1945685__defec_tives
detectives1645785__detec_tives
ejectives2145445___ejec_tives
electives1448935___elec_tives
executes1736535___execut__es
executions1946395___executions
executrices2251905___executrices
executrixes1951285___executrixes
inconsecutive2062505incon_secutive_
invectives1885905_in_vec_tives
nonactive1448975non__ac_tive_
nonconsecutive2173025nonconsecutive_
noncreative1648235noncre_ative_
nondeceptive2053735non_deceptive_
nondeductive1953765non_deductive_
nondirective1854685nondirec_tive_
nonelected1355695nonelec_t__ed
nonelection1347205nonelec_ti_on
nonentities1158265none_ntiti_es
nonevaluative1982485nonevaluative_
nonexempts2151715nonexempt___s
nonexploitive2561915nonexploitive_
nonexplosive2461985nonexplosive_
noninductive1854215noninductive_
noninfective2054585noninfec_tive_
nonnatives1345645non___natives
nonnegative1555175non_negative_
nonobjective2663545nonobjec_tive_
nonoperative1756285nonoperative_
nonreactive1645955non_reactive_
nonrelative1456835non_relative_
nonspeculative2161995nonspeculative_
objectives2444535_o_bjec_tives
reexecutes1962625_reexecut__es

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 Filter1786911247900.393454684.5
2DLD Change Limit124790547.87315850.4
3Display Results54540.0331636.4
 (SQL Overall)178691548.29921531.6
 
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.