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

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

96 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
undesired114752(None) 
desired9311982__desired
undecided1445982undecided
undefiled1446112undefiled
undefined1445872undefined
undenied102211562undeni_ed
underbred1338992underbred
underived14310512underived
undersized2148212undersized
undeserved1544162undeserved
unretired1046432unretired
andesite949453andesite_
andesites1048553andesites
deaired9411533__deaired
desire7415303__desire_
desirer8310783__desirer
desires81316133__desires
endeared1038053ende_ared
sundered10312153sunde__red
unadmired1343863unadmired
unaired82916013un__aired
unassured1084353unassured
unattired1045083unattired
unbeared111611653unbe_ared
uncensored1354253uncensored
uncensured1344003uncensured
unchaired1536203unchaired
undebated1338093undebated
undecayed1645173undecayed
undeceived1743993undeceived
undecideds1542233undecideds
undecked16238493unde_cked
undeclared1445043undeclared
undefaced1644753undefaced
undeformed1743373undeformed
undeleted1148063undeleted
undelivered1652643undelivered
undeluded1244363undeluded
undented102313953unde_nted
underaged121011233underaged
underfed13311713unde_rfed
underfeed1448633underfeed
undergird1245903undergir_d
undergirded1544013undergirded
undergrad1245483undergrad
underlined121610213underlined
undermined14189133undermined
underscored1545143underscored
underserved1644633underserved
undersexed1946083undersexed
undershirted1753473undershirted
underside11310143underside_
undersides1248693undersides
undersigned14114973undersigned
undersize1949513undersize_
underused1139333underused
underwire1348123underwire_
underwires1447023underwires
undeterred1263833undeterred
undivided1544303undivided
undrained1138523undrained
undressed1138343undres_sed
undried92314613und_ri_ed
unedited10249833un_edited
unensured1044943unensured
unexpired1943283unexpired
unfeared121511013unfe_ared
unfired112212453un__fired
unhaired12238763un_haired
unhired112512153un__hired
uninspired1342573uninspired
uninsured1044873uninsured
unlevied1236843unlevi_ed
unmeasured1343303unmeasured
unmerited1239643unmerited
unmeshed1437003unmes_hed
unpaired11208943un_paired
unrefined1345463unrefined
unreserved1443903unreserved
unrested91914513unres_ted
unrestored1165113unrestored
unretire846963unretire_
unretires945933unretires
unrevised1345163unrevised
unseared91113943unse_ared
unsecured1244903unsecured
unseized1838443unse_ized
unsized172510543un__sized
untenured1044933untenured
untested92612413untes_ted
untired82316383un__tired
unveiled1298163unve_iled
unveined1258003unve_ined
unvested122210223unves_ted
unvisited1345173unvisited
unwearied1336763unwearied

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.436409841.7
2DLD Change Limit148641967.01621186.0
3Display Results96960.0462087.0
 (SQL Overall)178691967.49823831.8
 
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.