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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
underactive174596(None) 
interactive1659632interactive
underachieve21162722underachieve
underacting1547522underacting
counteractive2055953counteractive
detractive1647373__detractive
federative1746163federa_tive
hyperactive2456293hyperactive
indurative1447283indura_tive
overactive1847263_overactive
ulcerative1545173ulcera_tive
unattractive1752423unattractive
uncreative1547533uncrea_tive
undeceive1544773unde__ceive
underachieved23172303underachieved
underachiever22172233underachiever
underachieves22172513underachieves
underact11311513underact___
underacted1449253underact_ed
underactivity2272463underactivity
underacts1248583underact__s
underate9918603undera_t__e
unselective1653763unselective
abstractive1854894abstractive
attractive1545554_attractive
contractive1849524contractive
decoctive1745864__decoctive
deductive1645474__deductive
defective1848004__defective
detective1548104__detective
directive1557774__directive
distractive1746784distractive
durative1239074__dura_tive
enactive1338514___enactive
enumerative1654754enumera_tive
erective13311834___erective
extractive2246604_extractive
generative1458574genera_tive
hyperactives2555274hyperactives
ideative1238574_ide_a_tive
imperative1748564impera_tive
inactive1348204in___active
indicative1647714indica_tive
inductive1547264ind__uctive
infective17108974infe__ctive
injective2178024inje__ctive
inoperative1646754inopera_tive
instructive1656484instructive
integrative1547124integra_tive
interacting14411714interacting
interaction13411814interaction
interactively2155174interactively
interdictive1855314interdictive
invective1798044inve__ctive
iterative12410714_itera_tive
lacerative1556284lacera_tive
narrative1247374_narra_tive
negative1239084_n_ega_tive
neuroactive1653884_neuroactive
nonactive1448974_n_onactive
nondeductive1953764nondeductive
nondirective1854684nondirective
nonreactive1645954_nonreactive
operative141110554_opera_tive
protractive1855634protractive
putrefactive2251484putrefactive
radioactive1753324radioactive
reactive13310474__re_active
refractive1846694_refractive
subtractive1854664subtractive
tolerative1346254tolera_tive
tractive13310044___tractive
uncoercive1753004uncoer_c_ive
undeceived1743994unde__ceived
undeceives1643864unde__ceives
underachievers23181784underachievers
underactivities2162744underactivities
underage101012274undera___ge
underbite1249814under__bite
undercover1645094under_c_over
undereating1369554undereating
underived14310514under___ived
underlie91413124under__li_e
underline101714674under__line
undermine122012234under__mine
underprice1545514under_price
underrate10411894underrat__e
underrating1388254underrating
underreacting1752834underreacting
underripe1247834under__ripe
underscore1345804undersc_ore
underside11310144under__side
undersize1949514under__size
understate1148864under_state
undertake1448274under__take
undertint10414864under__tint
undertone10510204under__tone
undervote1357754undervot__e
underwire1348124under__wire
underwrite1446314under_write
undidactic1651864undidacti_c
unfertile1246414unfer__tile
unperceived1952974unper_ceived
unperceptive2163074unperceptive
unreceptive1853214unreceptive
unreflective2052674unreflective

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191069.25016088.5
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.71918385.7
 
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.