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

79 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
recentest1141028(None) 
decentest1249081decentest
recenter102715442recente_r
recentness1245462recentness
ancientest1255373ancientest
contest93523233__contest
decenter112412163decente_r
decenters122410373decenters
decentres12238523decentres_
decongest1345633decongest
detentes92712873detentes_
detentist1049323detentist
evenest10312103_even_est
frequentest2352653frequentest
greenest9312623gre_en_est
greeniest1039033gre_eniest
indecentest1454733indecentest
keenest11410963ke_en_est
precented14310693precente_d
precents123015043precent_s_
presentist12410093presentist
recanes93222263recan_es_
recanted112513513recante_d
recanter101913153recante_r
recanters112310483recanters
recants93217093recant_s_
recedes102816063rece_des_
receives1339743receives_
recement12315653rece_ment
recencies13312253recencies_
recent83630853recen___t
recently1339423recent_ly
recepts113010263recept_s_
recesses10312323recesses_
recites93524583rec_ites_
reconnect1347043reconnect
reconquest2153793reconquest
recontact1347163recontact
reconvert1449473reconvert
recrates102420373recrates_
recreates11313363recreates_
redenies9615713redenies_
reechiest1446013reechiest
reediest92815423re_ediest
reefiest112811483re_efiest
reekiest122711313re_ekiest
reenlist8410363re_enlist
reenter73217793re_ente_r
reenters82915303re_enters
refences13311843refences_
regents83416543regent_s_
reinvest1138203re_invest
relented92614943relente_d
relentless1043703relentless
relents74018503relent_s_
remotest103310723re_motest
renest64529713r__en_est
rentes65431193r__entes_
repentant1149313repentant
repented112614983repente_d
repenter102813863repente_r
repenters112511553repenters
repents93717623repent_s_
rerented92516163rerente_d
rerents73319423rerent_s_
resented92716963resente_d
resentment1248073resentment
resents74221223resent_s_
retenes76324623reten_es_
retest64028453r__e_test
revenges1238983revenges_
revenues1138663revenues_
scantest101710183_scantest
secretest1147033secretest
serenest82717623seren_est
silentest948103silentest
teeniest82112413te_eniest
trecentos1155873trecentos_
weeniest112411213we_eniest

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641797.51319784.5
3Display Results79790.0332393.9
 (SQL Overall)178691797.70223200.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.