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

134 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
unboarded1318568(None) 
unbearded13146341unbearded
boarded113910502__boarded
reboarded1365612reboarded
unawarded1444922unawarded
unbanded123010562unb_anded
unbarbed13217752unb_arbed
unbarred11238702unb_arred
unbeared111611652unbear_ed
unbonded12299762unbo_nded
unbounded1335412unbounded
unbraided1336132unbraided
unbranded1336362unbranded
uncarded12310132un_carded
unguarded1244102unguarded
unloaded1049532unloa_ded
uphoarded1662272uphoarded
barded105426423__b_arded
bearded114212133__bearded
boarder103910323__boarder
debearded1443373debearded
hoarded12368343__hoarded
inboard1037063inboar__d
inboards1145843inboard_s
inbounded1343763inbounded
keyboarded2151743keyboarded
onboard1046503onboar__d
onloaded1044743onloa_ded
preboarded1663893preboarded
snowboarded1851583snowboarded
surfboarded1861723surfboarded
tabarded1234743tab_arded
unaborted1245733unabo_rted
unabraded1344893unabra_ded
unadded10238523un__added
unaided92414603un__aided
unalarmed1244633unalarmed
unarmed101811923un__armed
unbacked17268733unb_acked
unbaked143312893unb_a_ked
unbaled103315963unb_a_led
unbanned11279113unb_anned
unbased103513483unb_a_sed
unbasted112510073unb_asted
unbated103317733unb_a_ted
unbathed1437223unb_athed
unbended12279973unb_ended
unbiased1147153unbia_sed
unbiassed1243553unbiassed
unblamed1337193unbla_med
unblended13265853unblended
unblinded13295233unblinded
unblooded1343843unblooded
unblurred1243003unblurred
unbobbed1234413unbo_bbed
unbodied1237263unbo_died
unboiled112410373unbo_iled
unbolted1179323unbo_lted
unboned103014223unbo__ned
unbooted1188773unbo_oted
unbosomed1464253unbosomed
unbottled1244153unbottled
unbowed132610243unbo__wed
unboxed17249573unbo__xed
unbraced132310433unbra_ced
unbraked15289413unbra_ked
unbred92613303unb__r_ed
unburden11124293unb_urden
unburied11208513unb_uried
unburned11227413unb_urned
uncarted11312053un_carted
uncarved1438163un_carved
uncharged1636613uncharged
uncharred1536103uncharred
uncharted1538083uncharted
uncoated11314963uncoa_ted
uncoded11312743unco__ded
uncoerced1445313uncoerced
uncorked152210403unco_rked
unearned9310063un_earned
unevaded1336423uneva_ded
unfaded123111733un_fa_ded
unfeared121511013unfear_ed
unfolded1338313unfo_lded
unforced14239133unfo_rced
unforged13238623unfo_rged
unforked16218953unfo_rked
unformed14239573unfo_rmed
unfounded1435363unfounded
ungarbed12197063un_garbed
ungirded1136083un_girded
ungraded11209923ungra_ded
unhanded132910183un_handed
unharmed1438093un_harmed
unhooded13277873unho_oded
unhorsed1238833unho_rsed
unjaded16279143un_ja_ded
unladed92614373un_la_ded
unleaded10411333unlea_ded
unlearned1035653unlearned
unloader936643unloa_der
unmarked15248813un_marked
unmarred11258403un_marred
unmolded1237453unmo_lded
unmoored1137333unmoor_ed
unmourned1254153unmourned
unpadded1345183un_padded
unparted11310823un_parted
unrewarded1542993unrewarded
unroasted1036613unroasted
unrounded1135863unrounded
unscarred1235673unscarred
unseared91113943unsear_ed
unshaded13149263unsha_ded
unshared121510703unshar_ed
unsnarled1035743unsnarled
unsoaked1338853unsoa_ked
unsorted9312513unso_rted
unsounded1135543unsounded
unsourced1244833unsourced
unsoured9310063unsour_ed
unstarred1036363unstarred
unvaried1239683un_varied
unwarmed1437303un_warmed
unwarned1238453un_warned
unwarped1436873un_warped
unwearied1336763unwearied
unwooded13207443unwo_oded
unworked16238503unwo_rked
unworried1344013unworried
unwounded1444623unwounded
upbraided1542963upbraided
uploaded1234533uploa_ded
upsoared11154353upsoar_ed

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411345.92025108.3
3Display Results1341340.0632127.0
 (SQL Overall)1786911346.40627894.3
 
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.