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

154 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
beret7494636(None) 
beet66457541be_et
befret11315961befret
beget85632551beget
bereft114317301bereft
berets85822521berets
beset76739131beset
buret77444011buret
barbet104427882barbet
bare65460522bare_
bared85144482bared
barer74535802barer
bares75457132bares
barest85327692barest
barret84930482barret
bearer85323912bearer
beast76338642beast
beat66168302be_at
beaut75135212beaut
becket144619882becket
bedel84219392bedel
bedew114513032bedew
bee56262402be_e_
beef96233672be_ef
been65335782be_en
beep85931212be_ep
beer65635992be_er
beers75628392beers
beery105220122beery
bees65453382be_es
beets76131442be_ets
befit105222662befit
befrets1237612befrets
begat86629722begat
begets96215522begets
begot84625952begot
behest11314612behest
belt65754032be_lt
bene66439492bene_
benes75536232benes
bennet84823362bennet
bent67759912be_nt
berate84729022berate
beretta938462beretta
berg75425542ber_g
bergs84718042bergs
berk105929842ber_k
berks115423122berks
berm86732752ber_m
berme96022942berme
bermed115217722bermed
bermes106023002bermes
berms95323662berms
berry104521762berry
berth104917882berth
beryl101211672beryl
beses75830722beses
besets85718802besets
besot76429712besot
best66355322be_st
bet58376672b__et
betel74419902betel
bevel104517042bevel
bewept13410322bewept
bezel165215172bezel
bidet84935622bidet
blet66247672b_let
bluet75631192bluet
bore66051332bore_
bored85034302bored
borer75131272borer
bores76448252bores
bort65960962bor_t
brat66055542b_rat
bred75130972b_red
bree67241262b_ree
breed85526692breed
brees75632552brees
bren65629562b_ren
brent75734132brent
brevet115717332brevet
brew95023562b_rew
brit66350152b_rit
brut66537962b_rut
burets84321262burets
burnet84326172burnet
burnt75230322burnt
burst75332242burst
byre95023852byre_
byres104421382byres
caret75360562caret
cere66741472cere_
cered85227442cered
ceres75540012ceres
cermet10321152cermet
curet75447642curet
deet57356582de_et
derat65044082derat
dere56845902dere_
ebbet93517292ebbet
egret63327312egret
ere36352772_ere_
erect74129332_erect
erst47436432_erst
feet75352212fe_et
fere76342232fere_
feres86038182feres
ferret93021172ferret
fret75845042_fret
genet66038682genet
gerent73223092gerent
greet65835322greet
here76447102here_
hereat93527412hereat
heres86245902heres
hereto9313692hereto
keet85347332ke_et
leet45957902le_et
meet65350552me_et
mere67244442mere_
merer75126232merer
meres75143572meres
merest84725112merest
merit7339182merit
pere66450262pere_
perea75026442perea
peres76246642peres
pert66759322per_t
regret73723532regret
relet54749822relet
remet74843722remet
rerent63832452rerent
reset55051862reset
ret35982832__ret
revet84938842revet
rewet85135152rewet
secret8325062secret
sere46153472sere_
sered65737292sered
serer55935502serer
seres55448892seres
serest64831612serest
tenet55542212tenet
tercet83624912tercet
terete6319332terete
terret63425622terret
tret46653532_tret
verset94327322verset
verst84429372verst
vert77249372ver_t
vervet124619062vervet
weet75254152we_et
were76238332were_
wert79749822wer_t

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001541.83029398.9
3Display Results1541540.0305133.3
 (SQL Overall)1786911541.95391495.6
 
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.