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

108 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
unelected123782(None) 
unselected1344971unselected
elected102812612__elected
inflected1546052inflected
neglected1354692_neglected
nonelected1355692nonelected
prelected1439132prelected
reelected1238312reelected
selected1159782_selected
unalerted1047962unalerted
undeleted1148062undele_ted
undetected1444872undetected
unexpected2243112unexpected
unletted9310312un_letted
coerected1447643coerected
collected1447973collected
defected15289973_defected
deflected1635983deflected
dejected19307593_dejected
deleted93314913_dele_ted
deselected1444083deselected
detected12289733_detected
ejected17297653__ejected
electee92513243__electee
erected103213993__erected
eyeletted1342863eyeletted
infected14229403in_fected
inflicted1545533inflicted
injected18226753in_jected
inspected1445403inspected
invected14258883in_vected
neglecter1263633_neglecter
nonselected1454383nonselected
nucleated1247873nucleated
praelected1544393praelected
preelected1545783preelected
reejected1955093reejected
reerected1238613reerected
refected142311663_refected
reflected1547983reflected
rejected182710113_rejected
relented92614943_relented
relucted1138653_relucted
resected112514743_resected
reselected1345633reselected
selectee10910493_selectee
unabetted1244993unabetted
unacted10312733un__acted
unaffected1942943unaffected
unaverted1336563unaverted
unbelted1179333un_belted
unbleached1842763unbleached
unblenched1842563unblenched
unblended13265853unblended
unblessed1245323unblessed
unblocked1864353unblocked
unchecked2144063unchecked
uncleaned1237173uncleaned
uncleared1237543uncleared
unclenched1843353unclenched
uncliched1744623uncliched
uncollected1653673uncollected
uncreated12312303uncreated
undecked16238493un_decked
undefeated1546203undefeated
undelegated1444073undelegated
undented102313953un_dented
underacted1449253underacted
undirected1445023undirected
unedited10249833une_dited
uneducated1444523uneducated
unexalted1744333unexalted
unexcited1953983unexcited
unfelted1279403un_felted
unfledged1543563unfledged
unflexed1935263unfle_xed
unfluted1237173unfl_uted
unheated121514553un_heated
uninfected1663693uninfected
uninflected17112683uninflected
unlaced102913733un_lac_ed
unleaded10411333un_leaded
unleased9310713un_leased
unlevied1236843un_levied
unlicked15248263un_licked
unlisted9311153un_listed
unlocated1238383un_located
unlocked15268383un_locked
unmelted1169183un_melted
unmolested1343783unmolested
unplaced1338613unplac_ed
unplaited1236883unplaited
unplanted1236853unplanted
unpleased1236083unpleased
unpledged1443843unpledged
unplucked1843573unplucked
unrelated10310443unrel_ated
unrented92413923un_rented
unrested91914523un_rested
unscented1237513unscented
unseated91317683un_seated
unsliced1138093unslic_ed
untalented1144843untalented
untented92613413un_tented
untested92612423un_tested
untreated10312913untreated
unvested122210223un_vested
unwetted1238123un_wetted

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.453394461.4
2DLD Change Limit1486411087.08020994.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.57923577.1
 
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.