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

314 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
pye8643250(None) 
aye67151761aye
bye86134591bye
dye75334841dye
eye65539771eye
kye107327271kye
lye66533411lye
pe47649031p_e
pee56066511pee
pie55457401pie
pya87023751pya
pyes95528991pyes
pyre94925551pyre
pyx157817011pyx
rye66032541rye
tye65837441tye
wye96331971wye
ye57650061_ye
abye97921002abye
ace59656832ace
ae212590292_ae
age47154332age
ale36572342ale
ane37866942ane
ape57251182ape
apse67725382apse
are37874572are
ate37059242ate
ave67748702ave
awe67746622awe
axe108239492axe
ay511773892ay_
ayes76543512ayes
ays67050292ays
be47948942_be
bee56262402bee
bey86645422bey
by77529232by_
byes95230532byes
byre95023852byre
bys85229462bys
byte96521812byte
cee55952702cee
cue57544182cue
cyme119420372cyme
de37049542_de
dee47665822dee
dey77243372dey
die46759652die
doe47361952doe
due45249862due
dyed96720762dyed
dyer85522112dyer
dyes85331892dyes
dyke126418182dyke
dyne85320932dyne
eke75630092eke
eme55837182eme
epee64628502epee
ere36352772ere
eve66331162eve
ewe66630982ewe
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
eyne76322462eyne
eyre75525252eyre
fe57944742_fe
fee66862012fee
fey95940882fey
fie67152442fie
foe66350812foe
fyce126316832fyce
fyke145915292fyke
gae46457702gae
gee45359202gee
gey75738302gey
gie47149542gie
gybe105916242gybe
gym95719062gym
gyp98319012gyp
gyre84722762gyre
gyve116215082gyve
hae67364002hae
he58151952_he
hey96741062hey
hie67652702hie
hoe67562722hoe
hue66642302hue
hyp117822462hyp
hype125519812hype
hyte109018942hyte
ice56737242ice
ire36943172ire
jee106648642jee
joe106642352joe
kae76744542kae
key105833332key
kue76631862kue
kyes115124932kyes
kyte117017762kyte
lee36068142lee
ley66246812ley
lie38264522lie
lyes75530832lyes
lyre75623792lyre
lyse76320592lyse
mae57659102mae
me47748332_me
my78125652my_
myc106519502myc
nae35952742nae
ne27045102_ne
nee36657782nee
obe56638642obe
ode47446582ode
oe28473062_oe
oke75839482oke
ole37155212ole
one37050912one
ope56845242ope
ore36661832ore
ose38147342ose
owe67041032owe
oy58950132oy_
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
pa410456482p_a
pac79054082pac
pace86345772pace
pad68057322pad
page76036102page
pah88853592pah
pal56761672pal
pale66055012pale
pam77858392pam
pan58466442pan
pane64950282pane
pap76758402pap
par57467022par
pare66760842pare
pas58775742pas
pase65346862pase
pat58089462pat
pate65350462pate
pave96133892pave
paw87651172paw
pax127346852pax
pay88461182pay
payed115925932payed
payee105524722payee
payer105125722payer
pays95940222pays
pea56657242pea
pec76744412pec
ped66751522ped
peed76239182peed
peek106031432peek
peel65535612peel
peen65938082peen
peep85833692peep
peer66238352peer
pees65257372pees
peg65843062peg
peh86740962peh
peke105926202peke
pele65539552pele
pen56558842pen
pep76447082pep
per56353092per
pere66450262pere
pes57259782pes
pet56477302pet
pew86442302pew
phew128417112phew
phi86524202phi
pht86030522pht
phyle134111152phyle
pi48145362p_i
pia56848032pia
pic76046822pic
pice84641092pice
pied75035362pied
pier66035292pier
pies66949602pies
pig65744972pig
pike106335212pike
pile65649692pile
pin57066722pin
pine67755712pine
pip78051042pip
pipe86434432pipe
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
plie65127392plie
ply86323552ply
plyer106214332plyer
pod66351482pod
poem86225772poem
poet65552902poet
poh86740532poh
poi57244662poi
poke105335362poke
pol56449382pol
pole65951302pole
pom78249912pom
pome85636692pome
pone65747532pone
poo57757112poo
pop76252252pop
pope85535612pope
pore66451262pore
pose66441732pose
pot58078432pot
pow87147282pow
pox126140692pox
pree67044732pree
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
pro55837262pro
pry85728052pry
pryer104415312pryer
psi56621622psi
pst57932512pst
pub76037692pub
puce85127882puce
pud65836652pud
pug65337182pug
puke105025462puke
pul56138062pul
pule65040952pule
pun58846512pun
pup76339882pup
pur56840552pur
pure65543332pure
pus55547842pus
put55759072put
pyas96225702pyas
pyic116915822pyic
pyin96823232pyin
pyres105523882pyres
pyrex175211212pyrex
pyro96019392pyro
pyxes175911402pyxes
pyxie17359362pyxie
re26153742_re
ree37974072ree
roe36861072roe
rue35549262rue
rya67622012rya
ryes75529352ryes
ryke115616402ryke
sae38365182sae
see35772262see
she66837692she
snye77115492snye
spae65034322spae
spue66025522spue
spy86023742spy_
stye76218972stye
sue35651462sue
syce95820282syce
syke115420562syke
syn67024122syn
syne75725762syne
tae38267052tae
tee38366872tee
the67436052the
tie36557532tie
toe310166852toe
tyee75131422tyee
tyer75323392tyer
tyes76433372tyes
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
uke75727292uke
upbye1244792upbye
use36835162use
ute35335882ute
vee65750182vee
vie65447632vie
voe67739052voe
wae67556952wae
we57043452_we
wee66760812wee
woe66651242woe
wyes105727502wyes
wyle105519382wyle
wyn95921442wyn
wyte106018642wyte
ya510251502_ya
yea66445752_yea
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yes66250612_yes
yet66960692_yet
yew96436292_yew
yo59748552_yo
zee126143232zee
zyme1819114942zyme

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140843140.43632302.8
3Display Results3143140.0634984.1
 (SQL Overall)1786913140.562317955.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.