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

144 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
pyx15781701(None) 
pax127346851pax
pix126437931pix
pox126140691pox
pya87023751pya
pye86432501pye
apex137220212apex
ax911057782_ax
ay511773892ay_
aye67151762aye
ays67050292ays
box1210142342box
by77529232by_
bye86134592bye
bys85229462bys
cox1210346782cox
dex116936882dex
dye75334842dye
ex98835642_ex
eye65539772eye
fax138143312fax
fix136236102fix
fox136737862fox
gox117137182gox
gym95719062gym
gyp98319012gyp
hex137436172hex
hyp117822462hyp
kex146029582kex
kye107327272kye
lax107651522lax
lex107943822lex
lox108240962lox
lux106528772lux
lye66533412lye
lynx1437422lynx
max129045442max
mix126138172mix
my78125652my_
myc106519502myc
nix106932832nix
onyx1478362onyx
oryx14510212oryx
ox98242382_ox
oxy136320982oxy
oy58950132oy_
pa410456482p_a
pac79054082pac
pad68057322pad
pah88853592pah
pal56761672pal
pam77858392pam
pan58466442pan
pap76758402pap
par57467022par
pas58775742pas
pat58089462pat
paw87651172paw
pay88461182pay
pays95940222pays
pe47649032p_e
pea56657242pea
pec76744412pec
ped66751522ped
pee56066512pee
peg65843062peg
peh86740962peh
pen56558842pen
pep76447082pep
per56353092per
pes57259782pes
pet56477302pet
pew86442302pew
phi86524202phi
pht86030522pht
pi48145362p_i
pia56848032pia
pic76046822pic
pie55457402pie
pig65744972pig
pin57066722pin
pip78051042pip
pis56362032pis
pit56471922pit
piu56639542piu
pixy166117762pixy
plex137321372plex
ply86323552ply
pod66351482pod
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pot58078432pot
pow87147282pow
poxy166820892poxy
prex135722972prex
pro55837262pro
pry85728052pry
psi56621622psi
pst57932512pst
pub76037692pub
pud65836652pud
pug65337182pug
pul56138062pul
pun58846512pun
pup76339882pup
pur56840552pur
pus55547842pus
put55759072put
pyas96225702pyas
pyes95528992pyes
pyic116915822pyic
pyin96823232pyin
pyre94925552pyre
pyrex175211212pyrex
pyro96019392pyro
pyxes175911402pyxes
pyxie17359362pyxie
pyxis17458632pyxis
rax108445722rax
rex105740992rex
rya67622012rya
rye66032542rye
sax107447642sax
sex107043222sex
six105339742six
sox106444192sox
spy86023742spy_
syn67024122syn
tax109449152tax
tux105426572tux
tye65837442tye
vex136429172vex
vox136628152vox
wax137041182wax
wye96331972wye
wyn95921442wyn
ya510251502_ya
ye57650062_ye
yo59748552_yo
zax197630632zax

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.0602978183.3
2DLD Change Limit140841440.47029966.0
3Display Results1441440.0334363.6
 (SQL Overall)1786911440.563317390.8
 
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.