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

51 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
unbriefed155352(None) 
briefed1335742__briefed
debriefed1642142debriefed
unbridged1453922unbridged
unbridled1344972unbridled
briefer1235563__briefer
debriefer1541923debriefer
inbreed10267643inbr_e_ed
unabridged1542093unabridged
unbarbered1542883unbarbered
unbiased1147153unb_iased
unbilled1188693unb_illed
unbitted1138213unb_itted
unblinded13295233unblinded
unboiled112410373unboi_led
unbraced132310433unbr_aced
unbraided1336133unbraided
unbraked15289413unbr_aked
unbranded1336363unbranded
unbred92613303unbr___ed
unbreeched1842783unbreeched
unbridle1145393unbridle_
unbridles1244133unbridles
unbroiled1235803unbroiled
unbrowned1554053unbrowned
unbruised1244763unbruised
unbrushed1544433unbrushed
unburdened1442473unburdened
unburied11208513unburi__ed
uncrewed1456763uncr_ewed
undried92314613undri__ed
undrilled1146663undrilled
unfreed11510123unfr_e_ed
unfriended1542693unfriended
unordered1145293unordered
unpriced1338143unpri_ced
unprimed1337193unpri_med
unprinted1238133unprinted
unprized2038503unpri_zed
unreeled91310333un_reeled
unreeved12117673un_reeved
unribbed1334173un_ribbed
unrifled1237423un_rifled
unrigged1165643un_rigged
unrimed102211633un_ri_med
unrinsed938383un_rinsed
unripened1244393un_ripened
unripped1335763un_ripped
unroofed12106773un_roofed
untried82615853untri__ed
untrimmed1443563untrimmed

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 Limit148641517.46619909.1
3Display Results51510.0163187.5
 (SQL Overall)178691517.63823395.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.