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

257 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
unmarred1125840(None) 
unbarred11238701unbarred
unmarked15248811unmarked
unmarried1244581unmarried
gnarred9327002gn_arred
knarred12266002kn_arred
marred95421042__marred
unaired82916012un_aired
unarmed101811922un_armed
unbarbed13217752unbarbed
uncarded12310132uncarded
uncarted11312052uncarted
uncarved1438162uncarved
uncharred1536102uncharred
unearned9310062unearned
ungarbed12197062ungarbed
unhaired12238762unhaired
unharmed1438092unharmed
unharried1344762unharried
unmailed11229762unmailed
unmanned11268602unmanned
unmapped1535172unmapped
unmarrieds1341532unmarrieds
unmasked15267142unmasked
unmated103317022unma_ted
unmatted1138292unmatted
unmatured1245692unmatured
unmitred1136842unmitred
unmoored1137332unmoored
unpaired11208942unpaired
unparted11310822unparted
unscarred1235672unscarred
unstarred1036362unstarred
unvaried1239682unvaried
unwarmed1437302unwarmed
unwarned1238452unwarned
unwarped1436872unwarped
aneared8512743anea_red
barred95725793__barred
charred134614483_charred
debarred12165633debarred
demarked16187223demarked
demurred1234933demurred
dungareed1242433dungareed
embarred13174793embarred
enamored1147033enamored
enlarged1035413enlarged
garred85217403__garred
gnarled9287723gn_arled
inarmed10268673in_armed
incurred1136493incurred
inferred12248353inferred
infrared1236193infrared
instarred1043963instarred
interred92615263interred
jarred144613253__jarred
marked133921623__marked
marled95523163__marled
marrer83716673__marrer
married104715303__married
marted94425213__marted
nacred95212493_n_acred
narked114116743_n_arked
neared75119803_nea_red
numbered13147143numbered
outwarred1345473outwarred
parred95024073__parred
remarked15209243remarked
remarried1244933remarried
scarred104512633_scarred
smarted105012613_smarted
snared74824553sn_a_red
snarfed11378753sn_arfed
snarled83612363sn_arled
sparred104512863_sparred
starred85013453_starred
tarred74720283__tarred
ultrared936663ultrared
umbered121510113u_mbered
umpired1235783u_mpired
unacted10312733un_acted
unadded10238523un_added
unaged83916423un_a_ged
unagreed1036823unagreed
unaided92414603un_aided
unaimed102812493un_aimed
unalarmed1244633unalarmed
unamassed1244243unamassed
unamazed2035883unamazed
unamused1135793unamused
unarched14128553un_arched
unargued1035583un_argued
unarmored1244873un_armored
unarrayed1344183un_arrayed
unasked122010023un_asked
unawarded1444923unawarded
unawed103914903un_a_wed
unaxed144113093un_a_xed
unbacked17268733unbacked
unbaked143312893unba_ked
unbaled103315963unba_led
unbanded123010563unbanded
unbanned11279113unbanned
unbarbered1542883unbarbered
unbased103513483unba_sed
unbasted112510073unbasted
unbated103317733unba_ted
unbathed1437223unbathed
unbearded13146343unbearded
unbeared111611653unbeared
unblurred1243003unblurred
unboarded13185683unboarded
unbraced132310433unbraced
unbraked15289413unbraked
unbred92613303un__bred
unburied11208513unburied
unburned11227413unburned
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncanned11289963uncanned
uncapped1556693uncapped
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncatered1237403uncatered
uncaused1138453uncaused
unchaired1536203unchaired
uncharged1636613uncharged
uncharted1538083uncharted
uncorked152210403uncorked
uncrated11416313uncrated
uncurbed1346903uncurbed
uncured10513233un_cured
uncurled1168963uncurled
uncursed1148973uncursed
undamped1445333undamped
undated93118463unda_ted
underbred1338993underbred
underfed13311713underfed
undraped1239393undraped
undried92314613un_dried
unearthed1345573unearthed
unerased9312773unerased
unfaded123111733unfa_ded
unfairer11184283unfairer
unfaked153211173unfa_ked
unfavored1643443unfavored
unfazed20299053unfa_zed
unfeared121511013unfeared
unfired112212453un_fired
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unframed1478243unframed
unfreed11510123un_freed
unfurled1277203unfurled
ungalled1078463ungalled
ungated92717213unga_ted
ungirded1136083ungirded
ungraced12239143ungraced
ungraded11209923ungraded
unguarded1244103unguarded
unhailed12219963unhailed
unhairer11174993unhairer
unhalved1556513unhalved
unhanded132910183unhanded
unhanged13258833unhanged
unhatted1238183unhatted
unhired112512153un_hired
unhorsed1238833unhorsed
unhurried1343293unhurried
unimpaired1542053unimpaired
unjaded16279143unja_ded
unjammed2033623unjammed
unlabored1243803unlabored
unlaced102913733unla_ced
unladed92614373unla_ded
unlashed12289183unlashed
unlearned1035653unlearned
unmade92911063unma_de_
unmake122811213unma_ke_
unmaker13279513unma_ker
unmakers14256653unmakers
unmakes132810793unma_kes
unmanaged1344493unmanaged
unmannered1343833unmannered
unmasker14245023unmasker
unmatched1744203unmatched
unmeasured1343303unmeasured
unmelted1169183unmelted
unmended12299093unmended
unmerited1239643unmerited
unmerry1245023unmerr_y
unmeshed1437003unmeshed
unmewed13258173unm_ewed
unmilled1197853unmilled
unmined102612953unm_ined
unmitered1245853unmitered
unmitre936993unmitre_
unmitres1036863unmitres
unmixed17228213unm_ixed
unmolded1237453unmolded
unmourned1254153unmourned
unmoved13248903unm_oved
unnailed9229443unnailed
unnamed102410273unna_med
unnerved1248063unnerved
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unpa_ged
unpaved133410053unpa_ved
unpurged1236293unpurged
unraised91811883unraised
unraked122914013unra_ked
unranked1338563unranked
unrated82621553unra_ted
unrazed172511453unra_zed
unremarked1743203unremarked
unsalted9510923unsalted
unsated83419933unsa_ted
unsaved113312193unsa_ved
unsawed112911503unsa_wed
unseared91113943unseared
unserved12410233unserved
unshared121510703unshared
unsnarled1035743unsnarled
unsorted9312513unsorted
unsoured9310063unsoured
untacked15239923untacked
untagged1135973untagged
untamed102913223unta_med
untanned9279963untanned
untapped1376613untapped
untasted92011573untasted
untaxed152710583unta_xed
untired82316383un_tired
untraced112413243untraced
untried82615853un_tried
unturned9228563unturned
unurged939143un_urged
unvalued1266313unvalued
unversed122310433unversed
unwalled1288653unwalled
unwanted12249603unwanted
unwarier1136883unwarier
unwashed15288483unwashed
unwasted12259783unwasted
unwatered1345683unwatered
unwaxed18308393unwa_xed
unwearied1336763unwearied
unworked16238503unworked
unworried1344013unworried
updarted1244313updarted
upmarket1644663upmarket
warred104019843__warred

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622577.68619016.7
3Display Results2572570.1102336.4
 (SQL Overall)1786912577.96622431.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.