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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
revest9462360(None) 
devest104418701devest
reest54938091re_est
renest64529711renest
retest64028451retest
revert93529111revert
revests104413731revests
revet84938841reve_t
revets94022171revets
behest11314612behest
bravest124211752bravest
breves115516422breves_
brevet115717332breve_t
brevets12519392brevets
detest74122842detest
devests114410472devests
divest106820072divest
egest65222342_egest
event85924442_event
evert84929512_evert
eves76230462_eves_
fewest12311662fewest
feyest12311402feyest
freest95318282fre_est
geest64829612ge_est
gravest114011632gravest
greyest11348342greyest
invest93014842invest
lievest1048342lievest
livest95315732livest
merest84725112merest
neves87021872neves_
newest9314212newest
pretest9517632pretest
prevent124016552prevent
rarest65725482rarest
raves85441972raves_
rawest93615062rawest
realest73322432realest
reaves94127572reaves_
recast83422772recast
recent83630852recent
recept103319072recept
recess8314262recess
reddest9311952reddest
redes65139122redes_
rees45364192re_es_
reests64618892re_ests
reeves94721492reeves_
refect114319332refect
refelt94521422refelt
regent74127672regent
reges65628782reges_
reheat94423942reheat
reinvest1138202reinvest
reives95723042reives_
reject154116282reject
relent64431852relent
relet54749822rele_t
relets64025672relets
relist64628412relist
remeet86325472remeet
remelt85123122remelt
remet74843722reme_t
renests74014212renests
repast83520632repast
repeat85127212repeat
repent84728872repent
request16311022request
rerent63832452rerent
reseat64131492reseat
resect84424702resect
resent63833622resent
reset55051862rese_t
resets65427612resets
resist64524532resist
rest46459842r__est
retests73813852retests
reveal94115052reveal
revel84423162reve_l
revels94220572revels
reverb113912572reverb
revere94621252revere
revers94529632revers
reverse103913742reverse
reverso10367692reverso
reverts104715042reverts
revery124014212revery
revested122612242revested
revise94019742revise
revisit10311372revisit
revolt9316222revolt
revs75027052rev_s_
revues9813902revues_
revuist1038472revuist
rewet85135152rewe_t
rewets94617212rewets
rexes124526952rexes_
rifest93114582rifest
ripest84317932ripest
rives85336002rives_
rivet85636362rive_t
rivets94417112rivets
roves84834482roves_
rudest74016312rudest
serest64831612serest
trevet94818912treve_t
trevets10499972trevets
vest75743602__vest
weest85026772we_est

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit825511102.51632810.4
3Display Results1101100.0303666.7
 (SQL Overall)1786911102.66966950.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.