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 “phenix” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

211 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
phenix183713(None) 
phoenix1944361phoenix
helix154413012_helix
penis75129322p_enis
phenixes2035642phenixes
phenol1149252phenol
phenom1339472phenom
phenoxy2243482phenoxy
phenyl1435322phenyl
phonic133315212phonic
phrenic1438772phrenic
prefix18356852prefix
premix173710332premix
sphenic1449092sphenic
aphelia1249423aphelia
aphesis12610513aphesis
aphetic142912853aphetic
aphonia122711883aphonia
aphonic142713393aphonic
appendix2042273appendix
axenic154210003axenic
bemix165011453_bemix
chemic153012093chemic
deni56929393_deni_
denim85518843_denim
edenic9310223edenic
ephebi1345083ephebi_
ephebic1646513ephebic
euphenic1557203euphenic
fornix1636033fornix
genic85119393_genic
genie66124923_genie
genii64514173_genii
genip84415203_genip
heil76328933_he_il
heinie92512663_heinie
heir77523803_he_ir
helio85321193_helio
hemic125718623_hemic
hemin103620933_hemin
hen67555273_hen__
henbit111412003_henbit
hence104920043_hence
henge94819823_henge
henna84414043_henna
henry114014473_henry
hens75642573_hen_s
hent76656383_hen_t
hents87330743_hents
hernia9312293_hernia
hex137436173_he__x
hyenic1438723hyenic
hyphenic2147003hyphenic
irenic8311103irenic
lenis56326863_lenis
meninx1538703_meninx
nix106932833___nix
panic93923903p_anic
paynim1337363paynim
peeing94618083peeing
peen65938083peen__
peened94318153peened
peening103318303peening
peens76428193peen_s
peerie83617893peerie
peewit111110903peewit
pein65834943p_e_in
peins76128063p_eins
pekin111514423p_ekin
pen56558843p_en__
penal75228373p_enal
pence94924453p_ence
pencil103712973p_encil
pend75934533p_en_d
pends85527193p_ends
penes75839223p_enes
pengo84317593p_engo
penial84120893p_enial
penile82219603p_enile
penna74520203p_enna
penne75423853p_enne
penni74617903p_enni
pennia84412973pennia
pennis84315743pennis
penny105119453p_enny
pens65649643p_en_s
pensil83013333p_ensil
pent66559073p_en_t
peri65636973p_eri_
peril75425953p_eril
peris75537073p_eris
pernio8513143pernio
petit74332653p_etit
pewit104622793p_ewit
pfennig1362283pfennig
phasic133612053phasic
phasis114614923phasis
phatic133014413phatic
phelonia1347043phelonia
phenate12412193phenate
phenazin2245603phenazin
phenetic1549203phenetic
phenolic1546813phenolic
phenols1238103phenols
phenoms1437813phenoms
phenylic1844483phenylic
phenyls1534333phenyls
phew128417113phe__w
phi86524203ph__i_
phis95724903ph__is
phiz186718843ph__iz
phlox1737333ph_lox
phobia13278603phobia
phobic153010073phobic
phoenixes2143393phoenixes
phon95925383phon__
phonal11310383phonal
phone105621933phon_e
phoned124014553phoned
phones114121213phones
phoney143612983phoney
phonics143110723phonics
phonied133710563phonied
phonier122710633phonier
phonies123717513phonies
phonily1537103phonily
phoning13312053phoning
phono104917023phon_o
phonon114012033phonon
phonos114114793phonos
phons105221143phon_s
phony136715443phon_y
photic133316443photic
phrensy1533623phrensy
phylic16279553phylic
physic16288473physic
physis14359663physis
phytin14459013phytin
pianic103714123pianic
picnic123410263picnic
pieing93917653pieing
pionic103515953pionic
pix126437933p___ix
plena75816393plen_a
plench134010813plench
plenish1239943plenish
plenism11310113plenism
plenist9314333plenist
plenty11311413plenty
plenum1039503plenum
pleonic1139433pleonic
plex137321373ple__x
poetic10416843poetic
prebid113512843prebid
precis103416703precis
prelim10311423prelim
premie103617993premie
premixt183510663premixt
pretax152310193pretax
prex135722973pre__x
prolix1538683prolix
pterin81014153pterin
pyemia1337553pyemia
pyemic1537893pyemic
pyknic1734893pyknic
refix155212483_refix
remix145916553_remix
renig64518913_renig
renin54830033_renin
rhenium1246243rhenium
scenic10510513scenic
sheenie10159493sheenie
sheik122514663she_ik
shend94719973shen_d
shends105313773shends
shent85933503shen_t
sherif122915243sherif
sphene113412403sphen_e
sphenes123013163sphenes
sphenoid1446323sphenoid
spheric14510073spheric
sphinx1866203sphin_x
sphynx2152613sphyn_x
splenia948313splenia
splenic1148663splenic
splenii945543splenii
sthenia1058503sthenia
sthenic1268903sthenic
taenia6313193taenia
tenia55324483_tenia
thein85919023the_in
theine94814923theine
theins95015423theins
their85512153the_ir
then78429693then__
thenal92712423thenal
thenar92610003thenar
thence112010843thence
thens85921833then_s
thesis94913733thesis
thetic11412893thetic
venin85118663_venin
vernix1636633vernix
weenie92612023weenie
when105723043when__
whenas124610463whenas
whence14187923whence
whens114618763when_s
wienie9229973wienie
xenia124814773_xenia
xenic144114643_xenic

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162115.51620434.4
3Display Results2112110.0633349.2
 (SQL Overall)1786912115.71931245.1
 
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.