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

122 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
unopened113702(None) 
opened94311862__opened
reopened1138502reopened
unopen838912unopen__
unowned1148802uno_wned
unpenned1137542un_penned
unripened1244392unripened
convened143412223convened
coopered133310933coopered
cozened19349183_cozened
dampened1435623dampened
deepened1235653deepened
dovened12389063_dovened
dozened18377453_dozened
happened1635653happened
knopped16355443knop_ped
lippened13255223lippened
loosened945453loosened
omened93711003__omened
opener83910993__opener
opined95113853__opined
popeyed1535703_popeyed
propend123311273propen_d
propended1546163propended
propene112716043propene_
propenes122816513propenes
propined133111503propined
proponed132412033proponed
ripened1038203_ripened
tokened1236393_tokened
unamended1344853unamended
unaneled939793unaneled
unatoned939423unatoned
unavenged1443663unavenged
unbanned11279113unbanned
unbend9269773un_ben_d
unbended12279973un_bended
unblended13265853unblended
unboned103014223un_boned
unburned11227413unburned
uncanned11289963uncanned
unceded11410563un_ceded
unchewed1735803unchewed
uncleaned1237173uncleaned
uncoined111813023uncoined
uncovered1546613uncovered
uncrewed1456763uncrewed
undenied102211563un_denied
undented102313953un_dented
unearned9310063unearned
unended92811823un__ended
unevener1144123unevener
unexpended2142703unexpended
unfenced1437733un_fenced
unflexed1935253unflexed
unfreed11510123unfre_ed
ungowned1335183ungowned
unheeded1336893unheeded
unhoped13249353unhop__ed
unideaed1045733unideaed
unimpeded1542793unimpeded
unironed939083unironed
unjoined16248443unjoined
unkeeled13117183unkeeled
unkend11309223un_ken_d
unkenned1336183unkenned
unlined82515803un_lined
unloosened1142093unloosened
unmanned11268603unmanned
unmended12299093un_mended
unmewed13258173un_mewed
unmined102612953un_mined
unmourned1254153unmourned
unneeded1036483unneeded
unoffered1643363unoffered
unoiled82415473uno_iled
unopposed1443133unopposed
unordered1145293unordered
unpaged113311043un_paged
unpaved133410053un_paved
unpeeled11118533unpeeled
unpegged1334353un_pegged
unpen72913573un_pen__
unpens82511013un_pen_s
unpent83117373un_pen_t
unpiled102312743un_piled
unpinned1136383unpinned
unpointed1237153unpointed
unpoised1139183unpoised
unpolled1168943unpolled
unposed10711903un_posed
unposted1159433unposted
unpotted11108393unpotted
unpruned1136863unpruned
unreeled91310333unreeled
unreeved12117673unreeved
unrented92413923un_rented
unroped102812103unrop__ed
unscented1237513unscented
unseeded1038253unseeded
unsewed112911023un_sewed
unsexed152410253un_sexed
unsigned1037563unsigned
unspent92610893unspen_t
unsphered1556103unsphered
unstoned9311043unstoned
untanned9279963untanned
untended102611153un_tended
untented92613413un_tented
untuned82010823un_tuned
unturned9228563unturned
untwined1237063untwined
unveined1258003unveined
unvexed18147103un_vexed
unwakened1743623unwakened
unwarned1238453unwarned
unweaned1238593unweaned
unweeded1336563unweeded
unyeaned1237743unyeaned
unzoned172310653un_zoned
upend85011043u__pen_d
upended11267323u__pended

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.1561145455.1
2DLD Change Limit1461621227.34319904.9
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.54523683.4
 
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.