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

48 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
undesignated155283(None) 
designated1345932__designated
designate1147113__designate_
designates1246363__designates
predesignated1852313predesignated
undedicated1654813undedi_cated
undelegated1444073undeleg_ated
undersigned14114973undersign__ed
codesigned1542564codesign__ed
denigrated1366974__denigrated
desiccated1644994__desiccated
designator1244714__designator
designed1136944__design__ed
inseminated1445044insemi_nated
investigated17113914investig_ated
outdesigned1451494outdesign__ed
predesignate1652844predesignate_
predesignates1762634predesignates
presignaled1552384_presignaled
redesigned1343374redesign__ed
resinated10413284__resi_nated
unalienated1244014un_alienated
unassigned1262474unassign__ed
undebated1338094unde___bated
undecorated1545724unde_corated
undefeated1546204unde__feated
undefined1445874undefi_n__ed
undefoliated1752454undefoliated
undented102313954unde___n_ted
undercoated1546824unde_rcoated
underheated1647014unde_rheated
underinflated1852404underinflated
underrated12310854unde__rrated
understated1347844unde_rstated
undescended1643514undescen_ded
undesigning1453444undesign_ing
undesired1147524undesi___red
undigested13123844und__igested
unfeigned1453294unfe_ign__ed
ungerminated1653334ungerminated
unirrigated1353284unirrig_ated
unmediated1445164unmedi__ated
unmedicated1744104unmedi_cated
unmitigated1553724unmitig_ated
unmyelinated1851874unmyeli_nated
unsighted1455434un__sig_hted
unsigned1037564un__sign__ed
unweighted1843154unwe_ig_hted

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.406440125.6
2DLD Change Limit124790487.32617033.9
3Display Results48480.0331454.5
 (SQL Overall)178691487.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.