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

254 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
ply8632355(None) 
fly97124951fly
paly95835531paly
pay88461181pay
pily96132731pily
play95928981play
ploy96123601ploy
poly96235151poly
pry85728051pry
sly66228561sly
ably99725132ably
aby810238062aby
agly86821802agly
al210674042al_
ala312463602ala
alb57342652alb
ale36572342ale
alky115920342alky
all36148232all
ally76935642ally
alp56641132alp
als36663022als
alt36467962alt
amply125012912amply
any68440482any
apply125111392apply
aptly105111812aptly
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
buy86436542buy
by77529232_by
cay87155982cay
clay95927412clay
cloy96623832cloy
coly96940532coly
coy810557552coy
cry89726242cry
day76254112day
dey77243372dey
dry76526032dry
duly85323032duly
eely77725212eely
el26745292el_
eld46733792eld
elf66138522elf
elk76726122elk
ell36735682ell
elm57531742elm
elmy95616792elmy
els37645722els
fay97454862fay
fey95940882fey
flay106332802flay
fley106626852fley
flu66530212flu
foy96044262foy
fry96226502fry
gay76856492gay
gey75738302gey
gley85724652gley
goy77844552goy
guy75728942guy
haply135915062haply
hay97358772hay
hey96741062hey
hiply134113612hiply
holy106333432holy
hoy97447912hoy
icy86322122icy
idly85617322idly
ilk78325302ilk
ill37437092ill
illy76925332illy
imply124911832imply
inly75622212inly
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
la219261632_la
lay68865352lay
ley66246812ley
li29948752_li
lily76730182lily
lo28053442_lo
lye66533412_lye
may88757622may
moly96031912moly
my78125652_my
nay66952772nay
oily77932252oily
old47033462old
oldy85316842oldy
ole37155212ole
only75319722only
oxy136320982oxy
oy58950132_oy
pa410456482p_a
pac79054082pac
pacy115328682pacy
pad68057322pad
pah88853592pah
pal56761672pal
pale66055012pale
pall65039342pall
pally105727122pally
palm85331362palm
palmy126016732palmy
palp85828572palp
pals66951352pals
palsy105417462palsy
pam77858392pam
pan58466442pan
pap76758402pap
par57467022par
pas58775742pas
pat58089462pat
patly105020582patly
paty95234562paty
paw87651172paw
pax127346852pax
pays95940222pays
pe47649032p_e
pea56657242pea
pec76744412pec
ped66751522ped
pee56066512pee
peg65843062peg
peh86740962peh
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pen56558842pen
pep76447082pep
per56353092per
pes57259782pes
pet56477302pet
pew86442302pew
phi86524202phi
pht86030522pht
pi48145362p_i
pia56848032pia
pic76046822pic
pie55457402pie
pig65744972pig
pile65649692pile
pili66130352pili
pill65339462pill
pin57066722pin
piny911838352piny
pip78051042pip
pipy115421512pipy
pis56362032pis
pit56471922pit
pity96031932pity
piu56639542piu
pix126437932pix
pixy166117762pixy
plan65833942plan
plat66048872plat
platy105021662platy
playa105812942playa
plays106320772plays
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
plie65127392plie
plod76723272plod
plop86625742plop
plot66141232plot
plow95923232plow
ploys105816592ploys
plug74915992plug
plum85122102plum
plumy124213232plumy
plus66324832plus
plyer106214332plyer
pod66351482pod
pogy105623552pogy
poh86740532poh
poi57244662poi
poky135922152poky
pol56449382pol
pole65951302pole
poll66332132poll
polo66236632polo
pols66044562pols
polyp125611532polyp
polys105718762polys
pom78249912pom
pony96434052pony
poo57757112poo
pop76252252pop
posy96028422posy
pot58078432pot
pow87147282pow
pox126140692pox
poxy166820892poxy
pray96331532pray
prey96228482prey
pro55837262pro
psi56621622psi
pst57932512pst
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
pula65129372pula
pule65040952pule
puli65527622puli
pull64731662pull
pulp84825352pulp
pulpy124612362pulpy
puls65437562puls
pun58846512pun
puny95526992puny
pup76339882pup
pur56840552pur
pus55547842pus
put55759072put
pya87023752pya
pye86432502pye
pyx157817012pyx
ray66361992ray
rely75428952rely
reply104015852reply
ruly76323142ruly
say67264762say
shy96728192shy
sky106420992sky
slay76436382slay
soy67851452soy
spay96631662spay
splay105816042splay
spry96819122spry
spy86023742spy
sty66227312sty
thy97022912thy
toy69655192toy
try66529672try
ugly86012382ugly
ulu36028702ulu
upby1139062upby
waly105830902waly
way96757662way
why126920012why
wily106428812wily
wry96524702wry
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.0463884587.0
2DLD Change Limit140842540.39036112.8
3Display Results2542540.0465521.7
 (SQL Overall)1786912540.482370728.2
 
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.