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

164 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
unstained103868(None) 
unstrained1146371unstrained
abstained1245052abstained
destained1158252destained
distained1139602distained
stained84215342__stained
sustained1045382sustained
unchained1537272unchained
undrained1138522undrained
unscanned1245132unscanned
unstacked1636432unstacked
unstalked1435522unstalked
unstamped1454602unstamped
unstarred1036362unstarred
unstated91615812unsta_ted
unstayed12168392unsta_yed
unstinted1038562unst_inted
unstoned9311042unst_oned
unstriped1246302unstriped
untainted1038422un_tainted
untanned9279962un_tanned
untrained10510992untrained
untwined1237062un_twined
abstainer1144403abstainer
attained997353_attained
captained1446193captained
constrained1445353constrained
contained12310893contained
curtained1265503curtained
destined103312453dest_ined
detained103111643_detained
disdained1246023disdained
distrained1257673distrained
enchained1545493enchained
engrained1145493engrained
enshrined1344523enshrined
entailed989523en_tailed
entrained1089413entrained
entwined1235843en_twined
fountained1443333foun_tained
ingrained1145383ingrained
inshrined1344423inshrined
inspanned1242853inspanned
installed1045853installed
instanced1245703instanced
instarred1043963instarred
instated91613343insta_ted
intwined1235463in_twined
mistrained1347583mistrained
obtained1136533_obtained
pertained1238503pertained
restrained1148413restrained
retained93016093_retained
sained75424243__s_ained
stainer73614923__stainer
staned74824643__sta_ned
strained9412253__strained
suntanned1044013sun_tanned
sustainer944783sustainer
unaided92414603un__aided
unaimed102812493un__aimed
unaired82916013un__aired
unassailed1142913unassailed
unatoned939423unat_oned
unattired1045083unattired
unattuned1043343unattuned
unbanned11279113un_banned
unbraided1336133unbraided
uncanned11289963un_canned
unchaired1536203unchaired
unclaimed1435793unclaimed
uncoined111813023un_coined
uncurtained1452983uncurtained
undefined1445873undefined
unearned9310063un_earned
unexamined2042573unexamined
unhailed12219963un_hailed
unhaired12238763un_haired
unitized1839233unit_ized
unjoined16248443un_joined
unlearned1035653unlearned
unlined82515803un__lined
unmailed11229763un_mailed
unmanned11268603un_manned
unmined102612953un__mined
unnailed9229443un_nailed
unpainted1237183un_painted
unpaired11208943un_paired
unplaited1236883unplaited
unplanned1244413unplanned
unraised91811883un_raised
unrefined1345463unrefined
unrestrained1353283unrestrained
unsaid7411833uns_ai__d
unsalted9510923uns_alted
unsated83419933uns_a_ted
unsaved113312193uns_a_ved
unsawed112911513uns_a_wed
unscaled111410113unsca_led
unscarred1235673unscarred
unscathed1535313unscathed
unsealed91513623unsea_led
unseamed111210663unsea_med
unseared91113943unsea_red
unseasoned1143133unseasoned
unseated91317683unsea_ted
unseized1838443uns_eized
unshaded13149263unsha_ded
unshamed14148053unsha_med
unshaped14148443unsha_ped
unshared121510703unsha_red
unshaved15157733unsha_ved
unsigned1037563uns_igned
unsized172510543uns__ized
unslaked1338463unsla_ked
unsliced1138093uns_liced
unsnagged1243123unsnagged
unsnapped1443983unsnapped
unsnarled1035743unsnarled
unsoaked1338853unsoa_ked
unsoiled92412083uns_oiled
unspoiled12255563unspoiled
unstable10313763unstable_
unstabler1145623unstabler
unstate71916213unsta_te_
unstates81314993unsta_tes
unstating10711213unstatin_g
unsteadied1253853unsteadied
unsteeled1045763unsteeled
unstemmed1443303unstemmed
unstepped1444213unstepped
unstocked1645063unstocked
unstopped1444403unstopped
unstrapped1573563unstrapped
unstring9312093unstrin_g
unstrings1046013unstrings
unstudied1194283unstudied
unstuffed1642683unstuffed
unsuited9310793uns_uited
unswathed1634543unswathed
unswayed15155713unswa_yed
untacked15239923un_tacked
untagged1135973un_tagged
untamed102913223un_ta_med
untapped1376613un_tapped
untasted92011573un_tasted
untaxed152710583un_ta_xed
untied73720813un_t_i_ed
untimed102713373un_t_imed
untinged10308943un_t_inged
untired82316383un_t_ired
untried82615853un_tri_ed
untuned82010823un_t_uned
unturned9228563un_turned
untwine1038623un_twine_
untwines1137603un_twines
unveined1258003un_veined
unwarned1238453un_warned
unweaned1238593unwea_ned
unyeaned1237743unyea_ned
upstaged12135243upsta_ged
upstand1045343upsta_n_d
upstared11156573upsta_red
upstarted1244213upstarted

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.453394461.4
2DLD Change Limit1486411646.87621617.4
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.39224173.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.