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

173 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
rentes6543119(None) 
gentes75324161gentes
kentes105118641kentes
rente54733781rente_
rented74426591rented
renter64527411renter
renters74224811renters
rents55935181rent_s
yentes95517601yentes
antes56334322_antes
arenes64928392aren_es
arenites8917102arenites
aretes64425352are_tes
benes75536232ben_es
bennes86019012bennes
bentos86218302bentos
bents76033692bent_s
brents84717272brent_s
cenotes92814542cenotes
censes83721802censes
centas85020702centas
center84421412center
centers94420592centers
centos85920462centos
centres93817122centres
cents74730332cent_s
certes84623082certes
cetes75731102ce_tes
contes84432912contes
creates95225172creates
denes65639722den_es
denies74729642denies
denotes83817002denotes
dented84120512dented
dents65031802dent_s
enates64026422_enates
enter54726382_enter
enters64425642_enters
ernes55224812ern_es
fences114617112fences
fetes85630142fe_tes
frontes104214162frontes
genes65133092gen_es
genets75716662genets
genies75324942genies
genres75515622genres
gentles83714342gentles
gents65729612gent_s
gestes75721392gestes
henges104516452henges
hented104218752hented
hents87330742hent_s
jetes124922842je_tes
kente95821062kente_
lenes54738522len_es
lenites7818442lenites
lenses64620892lenses
lenten6312882lenten
lentos65317402lentos
mantes84430782mantes
menses84222452menses
mentee84121292mentee
mentees93214502mentees
metes74736212me_tes
montes84226932montes
nenes55329672nen_es
penates93321592penates
penes75839222pen_es
pontes83627852pontes
rances84625442rances
ranees64623962ranees
ranges73826922ranges
ranted74324702ranted
ranter63826822ranter
ranters73323642ranters
rants55935342rant_s
rates55352012r_ates
reales64934122reales
reatas64021012reatas
reaves94127572reaves
rebates95123172rebates
rebbes10313532rebbes
recces10614912recces
recites93524582recites
rectos85718782rectos
rectus83314632rectus
redates83423862redates
redes65139122re_des
redoes74623752redoes
redyes104214082redyes
reenter73217792reenter
reenters82915302reenters
rees45364192re__es
reeves94721492reeves
refutes104515722refutes
reges65628782re_ges
reinter73116842reinter
reinters82614772reinters
reives95723042reives
relates73731422relates
relets64025672relets
relies65036422relies
remates93827102remates
remotes94521612remotes
renames92418052renames
rended84524102rended
render74024142render
renders83821672renders
rends65129952ren_ds
reneges82513592reneges
renest64529712ren_est
renew83917512ren_ew
renews93811752renews
renigs74314592renigs
renins64526452renins
rennet64624852rennet
rennets75212632rennets
rent46661242rent__
rental63922022rental
rentals74017472rentals
rentier73618222rentier
rentiers83311762rentiers
reputes94615962reputes
resees63827482resees
resets65427612resets
reshes94124362reshes
resites74027792resites
rested74430782rested
rester63832432rester
resters74130402resters
rests54935872rest_s
rete44944132re_te_
retem74221952re_tem
retems83914572re_tems
retest64028452re_test
reties65436192reties
rets45352562re_t_s
retted74826312retted
reunites8312472reunites
reuses66025522reuses
revets94022172revets
revotes104716392revotes
revues9813902revues
rewets94617212rewets
rexes124526952re_xes
rinses64720382rinses
rites54442552r_ites
rotes56143902r_otes
rottes64524832rottes
routes66129312routes
runes55530222run_es
runts55927632runt_s
senates73322582senates
senses63923942senses
sente56432872sente_
tenets65518952tenets
tenses64722552tenses
tented74221002tented
tenter64623932tenter
tenters73921102tenters
tenths94412662tenths
tents56434212tent_s
tenues63816442tenues
testes65125822testes
trientes82812122trientes
venges104015142venges
vented104617922vented
venter94218722venter
venters103717722venters
vents86125932vent_s
venues95115202venues
yentas94614212yentas
yente86220042yente_

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.1261418182.5
2DLD Change Limit825511732.61031628.7
3Display Results1731730.0602883.3
 (SQL Overall)1786911732.79663909.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.