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

104 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
unentered103757(None) 
centered112513522_centered
entered82718882__entered
neutered937422_neutered
reentered1038572reentered
tentered96412102_tentered
unaltered1037722unaltered
uncatered1237402uncatered
unensured1044942unensured
unfettered1443652unfettered
unlettered1143952unlettered
unmitered1245852unmitered
unuttered1065732unuttered
unwatered1345682unwatered
bantered113313633_bantered
bettered113011843_bettered
cantered113415983_cantered
centred103411683_cent_red
chuntered1536663chuntered
concentered1645003concentered
countered12313003countered
decentered1445323decentered
enfettered1442483enfettered
engendered1342823engendered
enterer72015633__enterer
fendered13258673_fendered
festered122512113_festered
fettered12259493_fettered
gendered11258873_gendered
gettered10258613_gettered
indentured1243123indentured
lettered92910783_lettered
mentored1138003_mentored
metered103514013_me_tered
misentered1345913misentered
nattered92011623_nattered
neatened937043_neatened
peltered112510453_peltered
pestered112814973_pestered
petered103314973_pe_tered
rendered102512263_rendered
sauntered1036283sauntered
sceptered1444723sceptered
sheltered1335573sheltered
sintered92213903_sintered
skeltered1443873skeltered
sneakered1443713sneakered
sneered83113973sne__ered
sweltered1344453sweltered
teetered9258303_teetered
tendered102510603_tendered
unaneled939793unan_eled
unannexed1743543unannexed
unanswered1443023unanswered
unattired1045083unattired
unbuttered1353133unbuttered
uncensored1354253uncensored
uncensured1344003uncensured
uncovered1546613uncovered
undented102313953undent__ed
undeterred1263833undeterred
unended92811823unen__ded
unendowed1443143unendowed
unenforced1682733unenforced
unengaged1243013unengaged
unenjoyed2041993unenjoyed
unenlarged1242123unenlarged
unenvied1244653unen_vied
unexpired1943283unexpired
unfathered1743783unfathered
unfiltered1443563unfiltered
ungenteel1044233ungente_el
unhindered1543603unhindered
unindexed1843063unindexed
uninjured1743353uninjured
uninsured1044873uninsured
unintended1243513unintended
uninterest1045673uninterest
unkenneled1542333unkenneled
unmannered1343833unmannered
unmatured1245703unmatured
unmitred1136843unmit_red
unneeded1036483un_needed
unnerved1248063un_n_erved
unoffered1643363unoffered
unordered1145293unordered
unrenewed1344233unren_ewed
unrented92413923unrent__ed
unrestored1165113unrestored
unretired1046433unretired
unsphered1556103unsphered
untempered1544043untempered
untented92613413untent__ed
untenured1044933unten_ured
untethered1443713untethered
untired82316383u__ntired
untutored1043493untutored
unweathered1852503unweathered
uttered82712433u__ttered
veneered1235983_veneered
ventured1238273_ventured
weltered12238433_weltered
westered122511873_westered
wintered122111573_wintered

Search took 9 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.860207780.2
2DLD Change Limit1486411047.86018911.1
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.76620384.6
 
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.