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

138 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
underived1431051(None) 
coderived1644792coderived
derived123912762__derived
undeceived1743992undeceived
undecided1445982undecided
undefiled1446112undefiled
undefined1445872undefined
undenied102211562undeni_ed
underaged121011232underaged
underbred1338992underbred
underfed13311712under_fed
underfeed1448632underfeed
underlined121610212underlined
undermined14189132undermined
undersized2148212undersized
underused1139332underused
undesired1147522undesired
undried92314612und_ri_ed
unmerited1239642unmerited
unnerved1248062unner_ved
unserved12410232unser_ved
coderive1447693coderive_
coderives1547483coderives
deprived1546463__deprived
derided102914253__derided
derive103817043__derive_
deriver114213913__deriver
derives114017813__derives
genderized2274683genderized
inherited1348793inherited
innerved1246293inner_ved
maderized2247023maderized
nerved104111683_n_er_ved
sundered10312153sunder__ed
tenderized2175153tenderized
unbeloved1543923unbeloved
unburied11208513unburi_ed
uncarved1438163uncar_ved
undebated1338093undebated
undecayed1645173undecayed
undeceive1544773undeceive_
undeceives1643863undeceives
undecideds1542233undecideds
undecked16238493unde_cked
undefaced1644753undefaced
undeleted1148063undeleted
undelivered1652643undelivered
undeluded1244363undeluded
undented102313953unde_nted
underacted1449253underacted
underage101012273underage_
underages11811083underages
underate9918603underate_
underbaked1846173underbaked
underbid12108203under_bid
underbite1249813underbite_
underbites1347893underbites
underbud12136213under_bud
undercard1347003undercard
underclad1345563underclad
undercover1645093undercover
underdid11128133under_did
underdoes1139103underdoes
underdosed1346163underdosed
underfeeds1544233underfeeds
underfund1445373underfund
undergird1245903undergird
undergirded1544013undergirded
undergod1136583under_god
undergoer1146793undergoer
undergoes1139053undergoes
undergrad1245483undergrad
underhand1447263underhand
underlaid1147493underlaid
underlet91516213under_let
underlie91413123underlie_
underlies101414203underlies
underline101714673underline_
underlines111512113underlines
underload1146373underload
undermine122012233undermine_
undermines131710663undermines
underpaid1346963underpaid
underpinned1544053underpinned
underpriced1744613underpriced
underrated12310843underrated
underripe1247833underripe_
undersea9149883under_sea
underserved1644633underserved
underset91417133under_set
undersexed1946083undersexed
underside11310143underside_
undersides1248693undersides
undersigned14114973undersigned
undersize1949513undersize_
undersold1146883undersold
undertaxed1946513undertaxed
underuse939753underuse_
underuses1039913underuses
undervest1398673under_vest
underwire1348123underwire_
underwires1447023underwires
underwood1446473underwood
undeserved1544163undeserved
undivided1544303undivided
undrained1138523undrained
undraped1239393und_raped
undreamed1336973undreamed
undressed1138343undressed
undrilled1146663und_rilled
unedited10249833un_edited
unenvied1244653un_envied
unerased9312773un_erased
unlevied1236843unlevi_ed
unlived112511373un__lived
unnerve1066653unner_ve_
unnerves1157273unner_ves
unperceived1952973unperceived
unpriced1338143un_priced
unprimed1337203un_primed
unprized2038513un_prized
unproved1457533un_proved
unreeved12117673unre_eved
unrefined1345463unrefined
unrelieved1443513unrelieved
unretired1046433unretired
unrevised1345163unrevised
unrimed102211633un__rimed
unseized1838443unse_ized
unstriped1246303unstriped
untried82615853un_tri_ed
unvaried1239683unvari_ed
unveiled1298163unve_iled
unveined1258003unve_ined
unversed122310433unver_sed
unwearied1336763unweari_ed
updived1434093upd__ived
updried11226473upd_ri_ed

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.1561145455.1
2DLD Change Limit1486411387.22020587.4
3Display Results1381380.0602300.0
 (SQL Overall)1786911387.43624030.5
 
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.