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

54 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
unblurred124300(None) 
blurred10427802__blurred
unbarred11238702unb_arred
unburied11208512unb_uried
unburned11227412unb_urned
blurbed12337613__blurbed
blurted10399783__blurted
burred95820723__b_urred
incurred1136493in_curred
slurred8359193__slurred
sunburned1243563sunb_urned
unabjured1942803unabju_red
unalarmed1244633unalarmed
unalerted1047963unalerted
unaltered1037723unaltered
unbarbed13217753unb_arbed
unbearded13146343unbearded
unbeared111611653unb_eared
unblamed1337193unbl_amed
unblended13265853unblended
unblessed1245323unblessed
unblinded13295233unblinded
unblocked1864353unblocked
unblooded1343843unblooded
unboarded13185683unboarded
unbounded1335413unbounded
unbred92613303unb___red
unbruised1244763unbruised
unbrushed1544433unbrushed
unburden11124293unb_urden
unbusted11258773unb_usted
uncharred1536103uncharred
uncleared1237543uncleared
uncurbed1346903un_curbed
uncured10513233un_cu_red
uncurled1168963un_curled
uncursed1148973un_cursed
unfluted1237173unflu_ted
unfurled1277203un_furled
unglued937303unglu__ed
unhurried1343293un_hurried
unmarred11258403un_marred
unmourned1254153unmourned
unplucked1843573unplucked
unplugged1442743unplugged
unplumbed1642493unplumbed
unpurged1236293un_purged
unscarred1235673unscarred
unsourced1244833unsourced
unsoured9310063unsou_red
unsquared1944073unsquared
unstarred1036363unstarred
unturned9228563un_turned
unurged939143un__urged

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.406440125.6
2DLD Change Limit148641546.80021859.0
3Display Results54540.0301800.0
 (SQL Overall)178691547.23624694.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.