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

106 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
reentered103857(None) 
centered112513522_centered
decentered1445322decentered
entered82718882__entered
realtered1037892realtered
reenter73217792reenter__
reenters82915302reenter_s
reinterred1145152reinterred
relettered1144332relettered
rendered102512262r_endered
reuttered1036072reuttered
teetered9258302tee_tered
tentered96412102_tentered
unentered1037572unentered
bantered113313633_bantered
bettered113011843_bettered
cantered113415983_cantered
carpentered1652493carpentered
centred103411683_cent_red
chuntered1536663chuntered
countered12313003countered
decentred13236233decent_red
degendered1443503degendered
dewatered1444743dewatered
enterer72015633__enterer
fendered13258673_fendered
festered122512113_festered
fettered12259493_fettered
gendered11258873_gendered
gettered10258613_gettered
leistered1037043leistered
lettered92910783_lettered
meandered1346143meandered
mentored1138003_mentored
metered103514013_me_tered
misentered1345913misentered
neutered937423_neutered
peltered112510453_peltered
pestered112814973_pestered
petered103314973_pe_tered
prealtered1344943prealtered
raftered1237663r_aftered
reannexed1743063reannexed
recensored1344253recensored
recenter102715443recenter__
recovered15166733recovered
reemerged1354403ree_merged
reenacted1236853reenacted
reendowed1443593reendowed
reenforced1652983reenforced
reengaged1244133reengaged
reenjoyed2042533reenjoyed
reenlarged1242653reenlarged
reentering1149983reentering
reenthroned1552633reenthroned
reentries9311763reentries
reentry1038033reent_r_y
reested82916233reest__ed
refiltered1443773refiltered
regathered15124573regathered
registered1245293registered
reindexed1843883reindexed
reinjured1744533reinjured
reinserted1146683reinserted
reinsured1036983reinsured
reinter73116843reinter__
reinters82614773reinter_s
relented92614943relent__ed
remastered1345643remastered
remembered1743353remembered
renatured1047293renatured
renderer9239743r_enderer
reneged92010763r_en_eged
renewed11309993r_en_ewed
rented74426593r_ent__ed
renter64527413r_enter__
renters74224813r_enter_s
reoffered1643313reoffered
reordered1145383reordered
repapered1445233repapered
repented112614983repent__ed
repenter102813863repenter__
repenters112511553repenter_s
repowered1544663repowered
rerented92516163rerent__ed
resented92716963resent__ed
resentenced1455173resentenced
restored96417193r_estored
retempered1543433retempered
retextured1842403retextured
retired84620143r_e_tired
revered112819333r_e_vered
roistered1037643roistered
roystered1344873roystered
sauntered1036283sauntered
sceptered1444723sceptered
sheltered1335573sheltered
sintered92213903_sintered
skeltered1443873skeltered
sweltered1344453sweltered
tendered102510603_tendered
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.440406115.9
2DLD Change Limit1486411067.70019304.0
3Display Results1061060.0631682.5
 (SQL Overall)1786911068.20321783.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.