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

201 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
phenom133947(None) 
phenol1149251phenol
phenoms1437811phenoms
genom83716842_genom
phantom1436682phantom
phenix1837132phenix
phenols1238102phenols
phenoxy2243482phenoxy
phenyl1435322phenyl
phono104917022phono_
phonon114012032phonon
phonos114114792phonos
plenum1039502plenum
venom103914862_venom
adenoma1045403adenoma
ahem97225363ahe__m
besom95716973_besom
celom9515683_celom
chefdom18134063chefdom
chegoe1237273chegoe
chemo12313633chemo_
chemos13311723chemos
chino105823313chino_
chinos115018693chinos
coelom10310423coelom
denim85518843_denim
enol45823823__enol
enorm74415633__enorm
enow77819873__enow
envenom1244063envenom
epheboi1442983epheboi
ephebos1444113ephebos
erenow937373erenow
frenum1188803frenum
genoa64315823_genoa
genome94312193_genome
genoms94412483_genoms
guenon736403guenon
hansom11219153_hansom
helm95530023_he_lm
helo75332853_helo_
helos84928063_helos
helot85332683_helot
hem86148733_he__m
hen67555273_hen__
hence104920043_hence
henge94819823_henge
henna84414043_henna
henry114014473_henry
hens75642573_hen_s
hent76656383_hen_t
hents87330743_hents
herm95636153_he_rm
hero74635783_hero_
heron85025503_heron
heros84930863_heros
honor85718623_honor
keno87926433_keno_
kenos95220623_kenos
leno47331393_leno_
lenos56024863_lenos
meno66031353_meno_
nom510450643___nom
paeon74819493pae_on
paeons83915523paeons
pawnor11357243pawnor
paynim1337363paynim
peen65938083peen__
peened94318153peened
peens76428193peen_s
pekoe114612363p_ekoe
pelon74423213p_elon
pen56558843p_en__
penal75228373p_enal
pence94924453p_ence
pend75934533p_en_d
pends85527193p_ends
penes75839223p_enes
pengo84317593p_engo
pengos94612413p_engos
penis75129323p_enis
penna74520203p_enna
penne75423853p_enne
penni74617903p_enni
pennon8310643pennon
penny105119453p_enny
pens65649643p_en_s
pent66559073p_en_t
peon65635243p_e_on
peons75327183p_eons
peony105717563p_eony
pepo87622153p_epo_
pepos96620083p_epos
perm85834633p_e_rm
pernod9310453pernod
peso66925823p_eso_
pesos77221623p_esos
phaeton1235973phaeton
phantoms1545973phantoms
pharos11312063pharos
phellem1435833phellem
phenate12412193phenate
phenetol1344063phenetol
phenolic1546813phenolic
phenomena1645213phenomena
phenyls1534323phenyls
phew128417113phe__w
phlegm1433093phlegm
phloem1335703phloem
phlox1737333ph_lox
phoenix1944353phoenix
phon95925383ph__on
phonal11310383phonal
phone105621933phon_e
phoned124014553phoned
phoneme1446203phoneme
phones114121213phones
phoney143612983phoney
phonic133315203phonic
phonons123310253phonons
phons105221143phon_s
phony136715443phon_y
phot95534353ph__ot
photo104417223photo_
photog12379803photog
photon1111514823photon
photos113316633photos
phrenic1438773phrenic
phrensy1533623phrensy
phylon14318033phylon
phylum1655153phylum
phytol14366563phytol
phyton143610253phyton
piano76118713piano_
pianos84315933pianos
pinon76024533p_inon
pinot78737293p_inot
plena75816393plen_a
plench134010813plench
plenism11310113plenism
plenty11311413plenty
plenums1136533plenums
pleon74216383ple_on
pleons84213343pleons
plexor1535253plexor
poem86225773poe__m
pogrom1138593pogrom
pom78249913p___om
pompom1436493pompom
popedom1445453popedom
porno75120653porno_
pornos85015253pornos
prearm104512343prearm
preboom1348243preboom
preform1439603preform
prelim10311423prelim
prename11412643prename
prenomen1249633prenomen
prenoon9310043prenoon
preop94715873pre_op
pretor8315743pretor
prom87631693p__rom
rhebok1534613rhebok
rhenium1246243rhenium
rhetor938063rhetor
rheum1038843rhe_um
rhino84614323rhino_
rhinos94411123rhinos
senor53822793_senor
shalom11810913shalom
shend94719973shen_d
shends105313773shends
shent85933493shen_t
sheol84318363she_ol
sholom11910093sholom
sphene113412403sphen_e
sphenes123013163sphenes
sphenic1449093sphenic
sphenoid1446323sphenoid
steno54716863steno_
stenos63915773stenos
tenon53320513_tenon
tenor53620253_tenor
theism1139483theism
them97427043the__m
then78429693then__
thenal92712413thenal
thenar9269993thenar
thence112010843thence
thens85921833then_s
theonomy1644543theonomy
therm106018023the_rm
venoms114211213_venoms
whelm134611983whe_lm
when105723043when__
whenas124610463whenas
whence14187923whence
whens114618763when_s
whilom1436133whilom
whom127018173wh__om
xenon122612453_xenon

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 Limit1127162015.70319764.3
3Display Results2012010.0603350.0
 (SQL Overall)1786912015.90330271.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.