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

285 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
pry8572805(None) 
cry89726241cry
dry76526031dry
fry96226501fry
pay88461181pay
ply86323551ply
pray96331531pray
prey96228481prey
pro55837261pro
spry96819121spry
try66529671try
wry96524701wry
aby810238062aby
aery77231682aery
airy75734152airy
any68440492any
apery106517902apery
ar211379382ar_
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
army96624182army
ars37670932ars
art38679142art
arty77531312arty
aryl75922342aryl
awry107619682awry
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
bra56339462bra
bray95232902bray
bro56236602bro
brr56921922brr
bury95633592bury
buy86436542buy
by77529232_by
cay87155982cay
cory96941512cory
coy810557552coy
cru57129562cru
day76254112day
dey77243372dey
dory85836232dory
dray85428092dray
drys86314802drys
eery76129622eery
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738362ern
err35626532err
ers36046282ers
eyry106315882eyry
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fray105428902fray
fro65530642fro
fury107727972fury
gay76856492gay
gey75738302gey
gory86129662gory
goy77844552goy
gray85329892gray
grey85624042grey
guy75728942guy
hay97358772hay
hey96741062hey
hoy97447912hoy
icy86322122icy
ire36943172ire
irk76426362irk
ivy96317442ivy
jay136242672jay
joy137036362joy
jury146719592jury
kay106745542kay
key105833332key
lay68865352lay
ley66246812ley
lory75931712lory
may88757632may
miry96326752miry
my78125652_my
nary76931222nary
nay66952772nay
or27354732or_
ora37250832ora
orb55736862orb
orby97519602orby
orc57034922orc
ore36661832ore
orgy85218002orgy
ors35750112ors
ort39465232ort
oryx14510212oryx
oxy136320982oxy
oy58950132_oy
pa410456482p_a
pac79054082pac
pacy115328682pacy
pad68057322pad
pah88853592pah
pal56761672pal
paly95835532paly
pam77858392pam
pan58466452pan
pap76758402pap
par57467022par
para65242172para
pard76441322pard
pardy115523952pardy
pare66760842pare
park105237492park
parr65731152parr
parry105323752parry
pars67560792pars
part65967462part
party106630612party
pas58775742pas
pat58089462pat
paty95234562paty
paw87651172paw
pax127346852pax
pays95940222pays
pe47649032p_e
pea56657242pea
pec76744412pec
ped66751522ped
pee56066512pee
peery105719442peery
peg65843062peg
peh86740962peh
pen56558842pen
pep76447082pep
per56353092per
perdy115417332perdy
pere66450262pere
peri65636972peri
perk106232842perk
perky145319482perky
perm85834632perm
perp89029892perp
perry105222712perry
pert66759322pert
perv97224812perv
pes57259782pes
pet56477302pet
pew86442302pew
phi86524202phi
pht86030522pht
pi48145362p_i
pia56848032pia
pic76046822pic
pie55457402pie
pig65744972pig
pily96132732pily
pin57066722pin
piny911838352piny
pip78051042pip
pipy115421512pipy
pirn67128372pirn
pis56362032pis
pit56471922pit
pity96031932pity
piu56639542piu
pix126437932pix
pixy166117762pixy
play95928982play
ploy96123602ploy
pod66351482pod
pogy105623552pogy
poh86740532poh
poi57244662poi
poky135922152poky
pol56449382pol
poly96235152poly
pom78249912pom
pony96434052pony
poo57757112poo
pop76252252pop
pore66451262pore
porgy116916122porgy
pork106929682pork
porky145019332porky
porn65636022porn
porny106020192porny
port66059632port
posy96028422posy
pot58078432pot
pow87147282pow
pox126140692pox
poxy166820892poxy
pram85733492pram
prao66229022prao
prat65952042prat
prau66529472prau
prays105022432prays
pree67044732pree
prep86427672prep
prex135722972prex
prexy174611582prexy
preys105717782preys
prez156126312prez
pricy124814562pricy
prig75924872prig
prim85132202prim
privy13439832privy
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prop85932812prop
pros65742782pros
prosy106319252prosy
prow97030382prow
proxy175011012proxy
pryer104415312pryer
psi56621622psi
pst57932512pst
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
pun58846512pun
puny95526992puny
pup76339882pup
pur56840552pur
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
pursy105016412pursy
purty105019402purty
pus55547842pus
put55759072put
pya87023752pya
pye86432502pye
pyre94925552pyre
pyro96019392pyro
pyx157817012pyx
ray66361992ray
re26153742_re
rya67622012_rya
rye66032542_rye
say67264762say
scry96017762scry
shy96728192shy
sky106420992sky
sly66228562sly
soy67851452soy
spay96631662spay
spiry105017352spiry
spray106720062spray
spy86023742spy
sri35634002sri
sty66227312sty
thy97022912thy
tory75840542tory
toy69655192toy
tray77632592tray
trey77228792trey
troy77429682troy
upby1139062upby
updry1135482updry
urb55731112urb
urd46427052urd
urn35731472urn
urp56426402urp
vary105226062vary
very108025642very
wary106740012wary
way96757662way
why126920012why
wiry106422832wiry
yay96948712yay

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.266671770.7
2DLD Change Limit140842850.40634689.7
3Display Results2852850.0466195.7
 (SQL Overall)1786912850.718248873.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.