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

261 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
pekes11462356(None) 
dekes105224451dekes
ekes86726601_ekes
pedes85327281pedes
peeks115021111peeks
pees65257371pe_es
peke105926201peke_
pekoes124410421pekoes
peles75738081peles
penes75839221penes
peres76246641peres
pikes115031031pikes
pokes116133011pokes
pukes114523021pukes
aedes64625142aedes
akees96119242akees
apexes1539132apexes
bakes117035372bakes
bees65453382be_es
benes75536232benes
beses75830722beses
bikes117529472bikes
cakes116037672cakes
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
cokes115537192cokes
cukes115422092cukes
dees56356632de_es
deke95228762deke_
deked115718532deked
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dikes105831332dikes
dukes105023472dukes
dykes135215572dykes
eke75630092_eke_
eked96718022_eked
emes65434662_emes
epees75219832epees
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fakes126032482fakes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fykes156312692fykes
geeks104915842geeks
gees55647882ge_es
genes65133092genes
hakes126034302hakes
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hexes155123042hexes
hikes125426982hikes
hokes126231642hokes
jakes165023642jakes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
jokes165423332jokes
jukes165319102jukes
keeks84717252keeks
kexes166216812kexes
kikes85122552kikes
lakes95737652lakes
leeks95318892leeks
lees45455882le_es
leges64427282leges
leke85527402leke_
leks85427602lek_s
lenes54738522lenes
leses54930812leses
lexes127225262lexes
likes96231902likes
makes115336852makes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mikes115129892mikes
mokes114631032mokes
nenes55329672nenes
neves87021872neves
nukes95418122nukes
okes84936342_okes
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
pares77164482pares
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
peaces106324082peaces
peages94321842peages
peags86122842peags
peaked136117402peaked
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pe_as
pease75231112pease
peases85229472peases
peats76140192peats
pechs125516202pechs
pecked155019102pecked
pecker144615362pecker
peckers153312672peckers
pecks135724432pecks
pecs84634102pe_cs
peds75835242pe_ds
pee56066512pe_e_
peed76239182pe_ed
peek106031432pe_ek
peeked134314572peeked
peel65535612pe_el
peels75226422peels
peen65938082pe_en
peens76428192peens
peep85833692pe_ep
peeps95822362peeps
peer66238352pe_er
peers75130272peers
peeves113814872peeves
pegs75531762pe_gs
pehs95625762pe_hs
peins76128062peins
peise75825772peise
peises84125042peises
pekan111613972pekan
pekans121710552pekans
pekin111514422pekin
pekins121812232pekins
pekoe114612362pekoe
pele65539552pele_
pelfs105016292pelfs
pelts76128812pelts
pelves114514662pelves
pends85527192pends
penis75129322penis
pens65649642pe_ns
peones83821042peones
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
pere66450262pere_
perea75026442perea
peris75537072peris
perked134617682perked
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
perukes133210112perukes
pervs105117372pervs
pes57259782p__es
pesos77221622pesos
pests75933272pests
peter74427592peter
peters86624592peters
pets66248332pe_ts
pewee10319972pewee
pewees11311392pewees
pews95731532pe_ws
pieces104217272pieces
pies66949602p_ies
pikas114218092pikas
pike106335212pike_
piked125623312piked
piker115622842piker
pikers124717392pikers
pikis115116392pikis
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
plebes104313622plebes
plexes155313532plexes
plies74526512plies
poke105335362poke_
poked125425392poked
poker115122882poker
pokers124617922pokers
pokey145318972pokey
pokeys15529512pokeys
pokies125921332pokies
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
prees75937172prees
prexes154915942prexes
prezes173614692prezes
pries74339532pries
pubes94423402pubes
puces94924632puces
puke105025462puke_
puked124716222puked
pules74538812pules
puses75532202puses
pyes95528992p_yes
pyres105523882pyres
pyxes175911402pyxes
rakes94440352rakes
redes65139122redes
reeks94124032reeks
rees45364192re_es
reges65628782reges
rekey124014732rekey
rekeys13347692rekeys
rexes124526952rexes
rykes125513032rykes
sakes95540752sakes
seeks94724642seeks
sees45361052se_es
semes75731582semes
seres55448892seres
sexes126126222sexes
sikes96236082sikes
skees95023122skees
sokes95031422sokes
spikes124520712spikes
spokes124417212spokes
sykes124816862sykes
takes94437792takes
tees45353582te_es
teles54536002teles
tikes95628902tikes
tokes95234972tokes
tykes125817062tykes
ukes86122812_ukes
vees75439432ve_es
veges94118862veges
vexes155719122vexes
wakes126633652wakes
weeks125017862weeks
wees76249122we_es
wekas123911792wekas
yeses85119322yeses
yikes125117752yikes
yokes125223022yokes
zees136331892ze_es
zeks175815062zek_s

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 Limit538002611.75030742.9
3Display Results2612610.0803262.5
 (SQL Overall)1786912611.92392923.0
 
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.