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

281 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
cetes7573110(None) 
cates75951871cates
cedes84927321cedes
cees65941591ce_es
cepes94424461cepes
ceres75540011ceres
certes84623081certes
cete64934781cete_
cites74435581cites
cotes76347841cotes
cutes79438311cutes
fetes85630141fetes
jetes124922841jetes
metes74736211metes
acutes83917722acutes
aedes64625142aedes
antes56334322antes
aretes64425352aretes
ates45047922_ates
bates75846342bates
bees65453382be_es
beets76131442beets
benes75536232benes
beses75830722beses
betas75528762betas
betel74419902betel
betels84515062betels
beths105519222beths
bets67051442bet_s
bites75641172bites
butes714535872butes
bytes105217492bytes
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cartes86239472cartes
cases75048382cases
castes85631862castes
cate66254592cate_
cater74840702cater
caters85336492caters
cats66356342cat_s
caves105639702caves
cease75227652cease
ceases84427072ceases
cede74928762cede_
ceded96118552ceded
ceder85322232ceder
ceders93817672ceders
cedis84317082cedis
cee55952702ce_e_
ceils75019402ceils
celeb9314872celeb
celebs1037882celebs
cells75428062cells
cels65534972ce_ls
celts75325782celts
cenotes92814542cenotes
cense75121402cense
censes83721802censes
centas85020702centas
center84421412center
centers94420592centers
centos85920462centos
centres93817122centres
cents74730332cents
cepe84926652cepe_
ceps86125952ce_ps
cerates95428232cerates
cere66741472cere_
cered85227442cered
cereus85215522cereus
cerites94823432cerites
ceros74726072ceros
cess65326052ce_ss
cesses84221362cesses
cestas85018542cestas
cestos84718092cestos
cestus84412912cestus
cetanes9315132cetanes
cheths14389822cheths
chutes114615762chutes
cines75239682cines
cires74932912cires
cite65640342cite_
cited84421952cited
citer74827322citer
citers85022972citers
cities84524852cities
clepes104214622clepes
clues74623032clues
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
comtes106222812comtes
cones76457422cones
contes84432912contes
copes97747102copes
cores76361852cores
coses76949492coses
cote66648732cote_
coted85033852coted
cots68054842cot_s
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crates85736052crates
creates95225172creates
cremes104517992cremes
crepes105419342crepes
cries75438402cries
cubes95028162cubes
cues65438982c_ues
cukes115422092cukes
cures75645432cures
cute66440452cute_
cuter74728222cuter
cutest85820142cutest
cutesy114810732cutesy
cutey105819792cutey
cuteys11569972cuteys
cuties84927362cuties
cutis77723752cutis
cuts65841152cut_s
cyeses11510122cyeses
cymes1210118922cymes
dates65639152dates
dees56356632de_es
deets65330242deets
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
deter65028042deter
deters74724682deters
detest74122842detest
dexes135224512dexes
dites66339152dites
dotes65836692dotes
eches106322162eches
ekes86726602_ekes
emes65434662_emes
eses45336102_eses
etas46432272_etas
eths76619522_eths
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fates85139232fates
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetas85624402fetas
fete75734922fete_
feted94420932feted
fets75345942fet_s
fetus85816542fetus
fezes175220022fezes
gates65939502gates
gees55647882ge_es
genes65133092genes
gentes75324162gentes
gestes75721392gestes
getas65421482getas
gets55442482get_s
gites65630182gites
hates86742572hates
hebes105521672hebes
hemes105031082hemes
heres86245902heres
heths116317782heths
hets75547202het_s
hexes155123042hexes
jees115938542je_es
jefes155613672jefes
jete115927252jete_
jets115834102jet_s
jutes125125132jutes
keets95123482keets
kentes105118642kentes
kexes166216812kexes
kites95432542kites
kytes125012912kytes
lees45455882le_es
leets54927122leets
leges64427282leges
lenes54738522lenes
leses54930812leses
lethes94818082lethes
lets47147942let_s
lexes127225262lexes
lutes55836662lutes
mates75251362mates
meets74224612meets
memes94927702memes
meres75143572meres
mete64438132mete_
meted85424432meted
meter75130322meter
meters85625832meters
meths105320232meths
metis75025902metis
metres85121562metres
mezes167719262mezes
mites75141802mites
motes75944002motes
mutes75033782mutes
nates55238332nates
nenes55329672nenes
nets45941532net_s
netts55320722netts
neves87021872neves
nites55736342nites
notes55034582notes
pates76047892pates
pedes85327282pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
peter74427592peter
peters86624592peters
pets66248332pet_s
rates55352012rates
redes65139122redes
rees45364192re_es
reges65628782reges
rentes65431192rentes
rete44944132rete_
retem74221952retem
retems83914572retems
retest64028452retest
reties65436192reties
rets45352562ret_s
rexes124526952rexes
rites54442552rites
rotes56143902rotes
sates54949322sates
scenes84520352scenes
scutes85219192scutes
sees45361052se_es
semes75731582semes
seres55448892seres
sets45549502set_s
setts55124322setts
sexes126126222sexes
sites56045432sites
tates55444982tates
tees45353582te_es
teles54536002teles
testes65125822testes
teths85418512teths
tets45847452tet_s
totes55139682totes
utes45930882_utes
vees75439432ve_es
veges94118862veges
vetoes92914082vetoes
vets76835092vet_s
vexes155719122vexes
votes84627082votes
wees76249122we_es
weets85427722weets
wets75940292wet_s
wites85536962wites
wytes114113432wytes
yentes95517602yentes
yeses85119322yeses
yetis85418392yetis
yetts86715132yetts
zees136331892ze_es
zetas145018162zetas

Search took 4 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.0762351197.4
2DLD Change Limit538002812.79619241.8
3Display Results2812810.1731624.3
 (SQL Overall)1786912813.04558683.4
 
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.