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

286 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
unwarned123845(None) 
unearned9310061unearned
unwarmed1437301unwarmed
unwarped1436871unwarped
unarmed101811922un_armed
unawarded1444922unawarded
unbanned11279112unbanned
unbarbed13217752unbarbed
unbarred11238702unbarred
unburned11227412unburned
uncanned11289962uncanned
uncarded12310132uncarded
uncarted11312052uncarted
uncarved1438162uncarved
ungarbed12197062ungarbed
unharmed1438092unharmed
unlearned1035652unlearned
unmanned11268602unmanned
unmarked15248812unmarked
unmarred11258402unmarred
unparted11310822unparted
untanned9279962untanned
unturned9228562unturned
unvaried1239682unvaried
unwakened1743622unwakened
unwalled1288652unwalled
unwanted12249602unwanted
unwarier1136882unwarier
unwashed15288482unwashed
unwasted12259782unwasted
unwaxed18308392unwa_xed
unweaned1238592unweaned
unwearied1336762unwearied
unworked16238502unworked
warned104018912__warned
aneared8512743anear_ed
awarded1236223_awarded
barned95623583__barned
bewared13310113bewar_ed
bulwarked1942443bulwarked
darned85018483__darned
dungareed1242433dungareed
dwarfed1533483_dwarfed
earned74818333__earned
enlarged1035413enlarged
gnarled9287723gn_arled
gnarred9327003gn_arred
gowaned1235763gowa_ned
inarmed10268673in_armed
interned93016653interned
inturned9268313inturned
inurned8328053in_urned
inwalled1275773inwalled
inward10310333inwar__d
knarred12266003kn_arred
learned8329303_learned
narked114116743_n_arked
neared75119803_near_ed
onward1039053onwar__d
outearned1056683outearned
outwarred1345473outwarred
prewarned1594773prewarned
reearned948883reearned
rewarded13229523rewarded
rewarmed14257433rewarmed
snared74824553sn_ar_ed
snarfed11378753sn_arfed
snarled83612363sn_arled
sunburned1243563sunburned
suntanned1044013suntanned
sunward1137653sunwar__d
swanned11358173_swanned
swarded1238153_swarded
swarmed1367483_swarmed
thwarted1533363thwarted
unacted10312733un_acted
unadded10238523un_added
unadorned1144123unadorned
unaged83916423un_a_ged
unagreed1036823unagreed
unaided92414603un_aided
unaimed102812493un_aimed
unaired82916013un_aired
unalarmed1244633unalarmed
unarched14128553un_arched
unargued1035583un_argued
unasked122010023un_asked
unatoned939423unatoned
unawaked1635903unawaked
unawakened1841923unawakened
unaware1038033unawar_e_
unawares1137053unawar_es
unawed103914903un_a_wed
unaxed144113093un_a_xed
unbacked17268733unbacked
unbaked143312893unba_ked
unbaled103315963unba_led
unbanded123010563unbanded
unbased103513483unba_sed
unbasted112510073unbasted
unbated103317733unba_ted
unbathed1437223unbathed
unbearded13146343unbearded
unbeared111611653unbear_ed
unboarded13185683unboarded
unboned103014223un_boned
unbraced132310433unbraced
unbraked15289413unbraked
unbranded1336363unbranded
unbred92613303un_br_ed
unburied11208513unburied
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncapped1556693uncapped
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncaused1138453uncaused
unchained1537273unchained
uncharged1636613uncharged
uncharred1536103uncharred
uncharted1538083uncharted
uncoined111813023uncoined
uncorked152210403uncorked
uncrated11416313uncrated
uncurbed1346903uncurbed
uncured10513233uncur_ed
uncurled1168963uncurled
uncursed1148973uncursed
undamped1445333undamped
undated93118463unda_ted
undaunted1145453undaunted
underfed13311713underfed
undrained1138523undrained
undraped1239393undraped
undried92314613un_dried
unearthed1345573unearthed
unerased9312773unerased
unfaded123111733unfa_ded
unfaked153211173unfa_ked
unfazed20299053unfa_zed
unfeared121511013unfear_ed
unfired112212453unfir_ed
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unframed1478243unframed
unfreed11510123un_freed
unfurled1277203unfurled
ungalled1078463ungalled
ungated92717213unga_ted
ungirded1136083ungirded
ungowned1335183ungowned
ungraced12239143ungraced
ungraded11209923ungraded
unguarded1244103unguarded
unhailed12219963unhailed
unhaired12238763unhaired
unhalved1556513unhalved
unhand10410383unha_n_d
unhanded132910183unhanded
unhanged13258833unhanged
unharness1245253unharness
unharried1344763unharried
unhatted1238183unhatted
unhired112512153unhir_ed
unhorsed1238833unhorsed
unironed939083unironed
unjaded16279143unja_ded
unjammed2033623unjammed
unjoined16248443unjoined
unkenned1336183unkenned
unlaced102913733unla_ced
unladed92614373unla_ded
unlashed12289183unlashed
unlined82515803un_lined
unmailed11229763unmailed
unmapped1535173unmapped
unmarried1244583unmarried
unmasked15267143unmasked
unmated103317023unma_ted
unmatted1138293unmatted
unmined102612953un_mined
unmourned1254153unmourned
unnailed9229443unnailed
unnamed102410273unna_med
unnerved1248063unnerved
unopened1137023unopened
unowned1148803un_owned
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unpa_ged
unpainted1237183unpainted
unpaired11208943unpaired
unpaved133410053unpa_ved
unpenned1137543unpenned
unpinned1136383unpinned
unplanned1244413unplanned
unpruned1136863unpruned
unpurged1236293unpurged
unraised91811883unraised
unraked122914013unra_ked
unranked1338563unranked
unrated82621553unra_ted
unrazed172511453unra_zed
unrewarded1542993unrewarded
unsalted9510923unsalted
unsated83419933unsa_ted
unsaved113312193unsa_ved
unsawed112911503unsa_wed
unscanned1245133unscanned
unscarred1235673unscarred
unseared91113943unsear_ed
unserved12410233unserved
unshared121510703unshar_ed
unsigned1037563unsigned
unsnarled1035743unsnarled
unsorted9312513unsorted
unstained1038683unstained
unstarred1036363unstarred
unstoned9311043unstoned
unswathed1634543unswathed
unswayed15155713unswa_yed
untacked15239923untacked
untagged1135973untagged
untainted1038423untainted
untamed102913223unta_med
untapped1376613untapped
untasted92011573untasted
untaxed152710583unta_xed
unthroned13106223unthroned
untired82316383untir_ed
untraced112413243untraced
untrained10510993untrained
untried82615853un_tried
untuned82010823un_tuned
untwined1237063untwined
unurged939143un_urged
unvalued1266313unvalued
unveined1258003unveined
unversed122310433unversed
unwariest1246033unwariest
unwarily1446363unwarily
unwariness1365883unwariness
unwarranted1552223unwarranted
unwary1239823unwar__y
unwasheds16233103unwasheds
unwatched1844083unwatched
unwatered1345683unwatered
unwed94114873unw___ed
unwedded1435393unwedded
unweeded1336563unweeded
unwelded1337133unwelded
unwetted1238123unwetted
unwilled1277823unwilled
unwind102610543unw_in_d
unwished15237833unwished
unwitted1237543unwitted
unwonted12248643unwonted
unwooded13207443unwooded
unwooed11229773unw_ooed
unworn93411333unworn__
unworried1344013unworried
unwound11126613unwoun_d
unwounded1444623unwounded
unwrapped1784133unwrapped
unyeaned1237743unyeaned
unzoned172310653un_zoned
updarted1244313updarted
upturned11214013upturned
upwafted1742193upwafted
upward12147163upwar__d
waned95831783__wa_ned
wanned104318013__wanned
warded115021043__warded
wared96339873__war_ed
warked144421213__warked
warmed124516893__warmed
warner93717223__warner
warped124816413__warped
warred104019843__warred
warted104223233__warted
yarned105514023__yarned
yearned11327373_yearned

Search took 10 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.1531167915.0
2DLD Change Limit1461622869.11316038.8
3Display Results2862860.1062698.1
 (SQL Overall)1786912869.37219066.5
 
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.