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

231 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
cepes9442446(None) 
capes95441921capes
cedes84927331cedes
cees65941591ce_es
cepe84926651cepe_
ceps86125951cep_s
ceres75540011ceres
cetes75731101cetes
clepes104214621clepes
copes97747101copes
crepes105419341crepes
aedes64625152aedes
apes66047432_apes
beeps95320972beeps
bees65453382be_es
benes75536232benes
beses75830722beses
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
cape87242782cape_
caped104931802caped
caper94831622caper
capers105428142capers
caphs124515372caphs
capos94826072capos
caps87147892cap_s
cares77369182cares
cases75048382cases
cates75951892cates
caves105639702caves
cease75227652cease
ceases84427072ceases
cede74928782cede_
ceded96118562ceded
ceder85322242ceder
ceders93817672ceders
cedis84317082cedis
cee55952702ce_e_
ceils75019402ceils
celeb9314872celeb
celebs1037882celebs
cells75428062cells
cels65534972ce_ls
celts75325782celts
cense75121402cense
censes83721802censes
cents74730332cents
cep75736332cep__
cere66741472cere_
cered85227442cered
cereus85215522cereus
ceros74726072ceros
certes84623082certes
cess65326052ce_ss
cesses84221362cesses
cete64934782cete_
chapes135421872chapes
cheeps135312912cheeps
cines75239682cines
cires74932912cires
cites74435592cites
clepe94617382clepe_
cleped115114122cleped
clues74623032clues
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
cope86847382cope_
coped105036852coped
copen94826432copen
copens106119962copens
coper95336092coper
copers104629842copers
copies104130312copies
cops86751372cop_s
copse95623932copse
copses104922482copses
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crapes104727692crapes
creeps104213622creeps
cremes104517992cremes
crepe95520722crepe_
creped114115722creped
crepey135110932crepey
cries75438402cries
cripes105120872cripes
cubes95028162cubes
cues65438982c_ues
cukes115422092cukes
cupel9514302cupel
cupels10310202cupels
cups85430822cup_s
cures75645432cures
cutes79438322cutes
cyeses11510122cyeses
cymes1210118922cymes
cypres1338532cypres
deeps84921772deeps
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dopes84935042dopes
dupes86425932dupes
eches106322162eches
ekes86726602_ekes
emes65434662_emes
epee64628502_epee
epees75219832_epees
epos66723732_epos
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
gapes86030822gapes
gees55647882ge_es
genes65133092genes
hebes105521672hebes
hemes105031082hemes
heres86245902heres
herpes115517322herpes
hexes155123042hexes
hopes105835642hopes
hypes135818672hypes
japes146322822japes
jeeps144715372jeeps
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
jupes145218552jupes
keeps116020282keeps
kepis115313362kepis
keps106027312kep_s
kexes166216822kexes
lees45455882le_es
leges64427292leges
lenes54738522lenes
leper74820742leper
lepers84817322lepers
leses54930812leses
lexes127225262lexes
lopes76437342lopes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mopes95134982mopes
napes74828462napes
neeps75617882neeps
nenes55329672nenes
neves87021872neves
opes65942612_opes
pedes85327292pedes
peeps95822362peeps
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
pepos96620082pepos
peps85134512pep_s
peres76246642peres
pes57259782__pes
pipes96030142pipes
popes95933812popes
rapes75740722rapes
redes65139132redes
rees45364192re_es
reges65628792reges
repeg84015052repeg
repegs93311942repegs
repel74921402repel
repels84318762repels
repos74725792repos
repps95114342repps
reps65937952rep_s
rexes124526952rexes
ripes75435772ripes
ropes75940062ropes
scapes105122262scapes
scenes84520352scenes
scopes104719592scopes
seeps74828752seeps
sees45361052se_es
semes75731582semes
sepses84515882sepses
septs75420602septs
seres55448892seres
sexes126126222sexes
sipes76036952sipes
supes75628302supes
tapes75838602tapes
tees45353582te_es
teles54536002teles
tepas76521682tepas
tepee74724212tepee
tepees84215242tepees
topes76941762topes
types105721062types
veeps104715722veeps
vees75439432ve_es
veges94118872veges
vexes155719122vexes
weeps104120562weeps
wees76249122we_es
wipes104827082wipes
yeps95924402yep_s
yeses85119322yeses
yipes106017842yipes
zees136331892ze_es
zeps156019342zep_s

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 Filter178691538000.313570897.8
2DLD Change Limit538002312.09025741.6
3Display Results2312310.0633666.7
 (SQL Overall)1786912312.46672461.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.