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

121 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
unchained153727(None) 
enchained1545491enchained
unchaired1536201unchaired
chained133812692__chained
uncanned11289962unc_anned
unchain1238942unchain__
unchains1338302unchain_s
unchanged1636282unchanged
uncharged1636612uncharged
uncharred1536102uncharred
uncharted1538082uncharted
unclaimed1435792unclaimed
uncoined111813022unc_oined
undrained1138522undrained
unhailed12219962un_hailed
unhaired12238762un_haired
unstained1038682unstained
untrained10510992untrained
archaised1545483archaised
archaized2445073archaized
chaine115119223__chaine_
chaines124518733__chaines
chaired134211243__chaired
chined125620063__ch_ined
cochaired1743883cochaired
enchain1248853enchain__
enchains1348523enchain_s
enchanted1546553enchanted
enchased1437383encha_sed
engrained1145493engrained
enshrined1344523enshrined
entrained1089413entrained
inclined1138643inc_lined
ingrained1145383ingrained
inshrined1344423inshrined
machined1637303mach_ined
unaided92414603un__aided
unaimed102812493un__aimed
unaired82916013un__aired
unbanned11279113un_banned
unbraided1336133unbraided
uncaged113314123unc_a_ged
uncaked143514353unc_a_ked
uncalcined1543713uncalcined
uncalled11810923unc_alled
uncapped1556693unc_apped
uncarded12310133unc_arded
uncarted11312053unc_arted
uncarved1438163unc_arved
uncased104216953unc_a_sed
uncashed14299763unc_ashed
uncasked15278453unc_asked
uncaused1138453unc_aused
unchaining1645693unchaining
unchair1236163unchai__r
unchairs1345503unchai_rs
unchancy1844703uncha_ncy
unchanneled1752473unchanneled
uncharge1446313uncharge_
uncharges1546213uncharges
unchaste1346923unchaste_
unchaster1445393unchaster
unchecked2144063unchecked
unchewed1735803unch_ewed
unchilled1545563unchilled
unchoked18257623unch_oked
unclamped1664503unclamped
unclasped1465503unclasped
unclawed1457983uncla_wed
uncleaned1237173uncleaned
uncoated11314963uncoa_ted
uncoffined1942423uncoffined
uncoiled112512683unc_oiled
uncombined1743793uncombined
unconfined1644433unconfined
uncracked18226803uncracked
uncrated11416313uncra_ted
uncrowned1564743uncrowned
uncurtained1452983uncurtained
undefined1445873undefined
unearned9310063un_earned
unexamined2042573unexamined
unhairer11174993un_hairer
unhalved1556513un_halved
unhand10410383un_ha_n_d
unhanded132910183un_handed
unhanged13258833un_hanged
unharmed1438093un_harmed
unhatted1238183un_hatted
unhinged13257473un_h_inged
unhired112512153un_h_ired
unjoined16248443un_joined
unlearned1035653unlearned
unlined82515803un__lined
unmailed11229763un_mailed
unmanned11268603un_manned
unmined102612953un__mined
unnailed9229443un_nailed
unpainted1237183un_painted
unpaired11208943un_paired
unplaited1236883unplaited
unplanned1244413unplanned
unraised91811883un_raised
unrefined1345463unrefined
unscanned1245133unscanned
unshaded13149263unsha_ded
unshamed14148053unsha_med
unshaped14148443unsha_ped
unshared121510703unsha_red
unshaved15157733unsha_ved
unstrained1146373unstrained
untainted1038423un_tainted
untanned9279963un_tanned
unthanked1764663unthanked
unthawed1535583untha_wed
unthroned13106223unthroned
untwined1237063un_twined
unveined1258003un_veined
unwarned1238453un_warned
unweaned1238593unwea_ned
unyeaned1237743unyea_ned

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.420425454.8
2DLD Change Limit1486411216.09624383.4
3Display Results1211210.0602016.7
 (SQL Overall)1786911216.57627173.2
 
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.