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 “unideaed” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
unideaed104573(None) 
undead82711902un_dea_d
unideal837102unidea_l
unindexed1843062unindexed
aniseed839403anise_ed
cindered1239793cindered
cnidae978143cnid_ae_
endeared1038053en_deared
hindered1339453hindered
hoidened1335653hoidened
ideated9310973__ideated
indeed83913563in_de_ed
indexed16347363in_dexed
nidated939863_nidated
nided75920883_nid__ed
sniveled1255463sniveled
sundered10312153sun_dered
unadded10238523unad_ded
unaided92414603unaid__ed
unaneled939793unaneled
unbeared111611653un_beared
unceded11410563un_ceded
unchewed1735803unchewed
uncleaned1237173uncleaned
uncleared1237543uncleared
uncreated12312303uncreated
uncrewed1456763uncrewed
undated93118463un_dated
undebated1338093un_debated
undecayed1645173un_decayed
undecked16238493un_decked
undee65327273un_de_e_
undefaced1644753un_defaced
undenied102211563un_denied
undented102313953un_dented
underaged121011243un_deraged
underfed13311713un_derfed
undimmed1434113undimmed
undraped1239393un_draped
undreamed1336973undreamed
undried92314613un_dried
undyed1138143un_d_yed
unedited10249833unedited
unfeared121511013un_feared
unflexed1935263unflexed
unfreed11510123unfre_ed
ungreased1136333ungreased
unhealed121511073un_healed
unheard1136943un_heard
unheated121514553un_heated
unhedged1434973unhedged
unheeded1336893unheeded
unhindered1543603unhindered
unified112413573uni_fied
unilobed1136393unilobed
unimbued1343073unimbued
unimpeded1542793unimpeded
unironed939083unironed
unisexes1554613unisexes
unissued934683unissued
unitard838003uni_tard
united74421543uni__ted
unitized1839233unitized
unkeeled13117183unkeeled
unlead73312373un_lea_d
unleaded10411333un_leaded
unleased9310713un_leased
unmewed13258173un_mewed
unmitered1245853unmitered
unneeded1036483unneeded
unopened1137023unopened
unordered1145293unordered
unpeeled11118533unpeeled
unpleased1236083unpleased
unread73412673un_rea_d
unreeled91310333unreeled
unreeved12117673unreeved
unriddled1243813unriddled
unripened1244393unripened
unsealed91513623un_sealed
unseamed111210663un_seamed
unseared91113943un_seared
unseated91317683un_seated
unseeded1038253unseeded
unsewed112911023un_sewed
unsexed152410253un_sexed
untidied1038903untid_ied
untread857413untrea_d
untreaded1137993untreaded
untreated10312913untreated
unvexed18147103un_vexed
unweaned1238593un_weaned
unwedded1435403unwedded
unweeded1336573unweeded
unyeaned1237743un_yeaned
widened12328053_widened

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 Filter1786911461620.406440125.6
2DLD Change Limit146162966.32623105.0
3Display Results96960.0332909.1
 (SQL Overall)178691966.76526414.0
 
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.