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

149 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
unbraid103718(None) 
unbraids1144961unbraids
upbraid1244971upbraid
braid85822262__braid
unafraid1242662unafraid
unbid83214642unb__id
unbrace111910482unbrace
unbraced132310432unbraced
unbraided1336132unbraided
unbrake13239122unbrake
unbraked15289412unbraked
unbred92613302unbr_ed
unlaid7311752un_laid
unpaid939472un_paid
unsaid7411832un_said
upbraids1343552upbraids
afraid1049723_afraid
ambroid1238883ambroid
android9311513android
aneroid8314003aneroid
brad75234343__bra_d
braids95015693__braids
brail75525553__brail
brain76229383__brain
brand85124493__brand
cornbraid1453683cornbraid
endbrain1144183endbrain
energid948303energid
engrail846263engrail
engrain838353engrain
entrain7313073entrain
fibroid1337243fibroid
hybrid15237813hybr_id
inboard1037063inboard
inbred93010403inbr_ed
inbreed10267643inbreed
ingrain839523ingrain
inlaid7310143in_laid
labroid1038823labroid
navaid1037653_navaid
nereid7312923_nereid
nonbrand1145383nonbrand
onboard1046503onboard
raid55243073___raid
subarid10310653subarid
umbra948513umbra__
umbrae1038683umbra_e
umbrage1236723umbrage
umbral1038633umbra_l
umbras1038643umbra_s
unabraded1344893unabraded
unai44824783un__ai_
unais53420773un__ais
unarmed101811923unarmed
unbaked143312893unbaked
unbale83616403unb_ale
unbaled103315963unbaled
unban72114333unb_a_n
unbans81912623unb_ans
unbar71913613unb_a_r
unbarbed13217753unbarbed
unbarred11238703unbarred
unbars82113033unb_ars
unbased103513483unbased
unbated103317733unbated
unbear889163unbea_r
unbeared111611653unbeared
unbears998043unbears
unbend9269773unb_end
unbiased1147153unbiased
unbind93011433unb_ind
unblamed1337193unblamed
unbodied1237263unbodied
unboned103014223unboned
unbound10158393unbound
unbowed132610243unbowed
unboxed17249573unboxed
unbraces12229413unbraces
unbracing1437023unbracing
unbraiding1445123unbraiding
unbrakes14258413unbrakes
unbraking1636933unbraking
unbranded1336363unbranded
unbridle1145393unbr_idle
unbroiled1235803unbroiled
unbroke13217743unbroke
unbruised1244763unbruised
unbuild1035723unbuild
unburied11208513unburied
unburned11227413unburned
unchain1238943unchain
unchair1236163unchair
unclad938913uncla_d
uncrate9415953uncrate
uncrated11416313uncrated
uncrazy2144063uncrazy
undead82711903undea_d
underbid12108203underbid
underdid11128133underdid
underlaid1147493underlaid
underpaid1346963underpaid
undid72415363un__did
undrained1138523undrained
undrape1049333undrape
undraped1239393undraped
undraw1037813undra_w
undrawn1145293undrawn
undraws1136893undraws
undried92314613undried
unerased9312773unerased
unfair936233un_fair
unframed1478243unframed
unfreed11510123unfreed
ungraced12239143ungraced
ungraded11209923ungraded
unguard955093unguard
unhair937333un_hair
unhand10410383un_hand
unheard1136943unheard
unitard838003unitard
unlead73312373unlea_d
unload73010803unloa_d
unnail6410583un_nail
unplait948603unplait
unraised91811883un_raised
unraked122914013un_raked
unrated82621553un_rated
unrazed172511453un_razed
unread73412673un_read
unrepaid1143713unrepaid
unrig61711413un_r_ig
unrip72012863un_r_ip
unsolid8138373unsolid
untraced112413243untraced
untrack1338703untrack
untrained10510993untrained
untread857413untread
untried82615853untried
untrim8310683untr_im
untrod769853untr_od
unurged939143unurged
unvaried1239683unvaried
unwrap11126323unwra_p
unwraps1255513unwraps
upbraided1542963upbraided
upbraider1442573upbraider
ursid6311483u__rsid
zebraic2044293zebraic
zebroid1936463zebroid

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271496.29621287.6
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.49827499.4
 
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.