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

224 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
phytins1531789(None) 
phytin14459011phytin_
phytons15319061phytons
chitins122713792chitins
patins87528782p_atins
pectins112315232pectins
photics142810482photics
photons123814432photons
physics17265962physics
physis14359662physi_s
phytane1545442phytane
phytanes1645762phytanes
phytols15276552phytols
phyton143610252phyton_
postins93721202postins
pyins105815862p_y_ins
rhytons13295882rhytons
acetins9313173acetins
actins86321103_actins
ayins85321613_ay_ins
biotins93114453biotins
chains114819703ch_ains
chins105631463ch__ins
chitin113114963chitin_
chitlins13289393chitlins
chitons122611913chitons
chopins142312243chopins
chuting132910733chuting
chymics19295533chymics
chytrids1744223chytrids
cortins92421333cortins
cretins93216423cretins
cutins83919983_cutins
cytons111710183_cytons
dentins83419223dentins
dhotis1038973dhoti_s
dhutis1035943dhuti_s
emetins9812653emetins
emptins1179403emptins
flyting14378553flyting
flytings15304793flytings
glycins1335563glycins
gratins84119183gratins
hating104929713_hating
hatpins123410643_hatpins
hemins113417573_hemins
hins76447993_h__ins
hyalins13229273_hyalins
hying126514743_hy_ing
hymens1437993_hymens
hymns1337523_hy_mns
hyoids1377673_hyoids
hyping15408483_hyping
hysons1237633_hysons
isatins7310773isatins
lattins74115483lattins
layins93817653lay_ins
lectins92515003lectins
leptins92412693leptins
lysins94610953_lysins
martins93322063martins
matins84527783_matins
mattins93316143mattins
mayvins1535323mayvins
muntins92715133muntins
pactions122613503pactions
pains75138283p__ains
panties94230933panties
panting104025423panting
papains11312363papains
partans94418283partans
parties93230863parties
parting103527383parting
partings113513733partings
partons94620513partons
pasties94529813pasties
pastils94416173pastils
pastina93914593pastina
pastinas103712153pastinas
pasting103826553pasting
pastis84924323pasti_s
patens84820863p_atens
patin76832853p_atin_
patina86022193p_atina
patinas96318523p_atinas
patine85328123p_atine
patines95225763p_atines
patios85221783p_atios
pattens95414923pattens
patties93425143patties
patting103722343patting
paulins9312613paulins
pavins114919663p_avins
paying123722163pay_ing
paynims1434973paynims
pectens11189203pectens
pectin102615533pectin_
pectines121914683pectines
peins76128063p__eins
pekins121812233p_ekins
pelting102917273pelting
pepsins11310433pepsins
peptics132610243peptics
peptids12239323peptids
pertains102113423pertains
petting103720953petting
pettings11349703pettings
phaetons1345853phaetons
phasing133211673phasing
phasis114614923phasi_s
phatic133014413phati_c
phenytoins1843743phenytoins
phis95724903ph__i_s
phobias14228183phobias
phobics16286703phobics
phocine1438833phocine
phonics143110723phonics
phonies123717513phonies
phoning13312053phoning
phonons123310253phonons
phons105221143ph__ons
photic133316443photi_c
photogs13358213photogs
photoing1439073photoing
photon1111514833photon_
photos113316643phot_os
phots105418503phot__s
phuts104613503phut__s
phyletics1944583phyletics
phylic16279553phyli_c
phyllos1535583phyllos
phylon14318033phylon_
physeds16344033physeds
physes14399783phy_ses
physic16288473physi_c
phytoid1678753phytoid
phytol14366563phyt_ol
phytonic1848203phytonic
pidgins11259123pidgins
pieties9419223pieties
piggins113010473piggins
pins65558453p___ins
pipkins15328183pipkins
pippins10319753pippins
pistils93314303pistils
pistons93016373pistons
pities83828083p_ities
pitons85319043p_itons
pitting103618873pitting
pittings11349123pittings
pitying132910243pitying
plains85019593p_lains
platans93413123platans
platens94213983platens
platies93722543platies
platina94413643platina
platinas103610313platinas
plating103823073plating
platings113611363platings
plutons938343plutons
plying124312083ply_ing
poetics11312073poetics
pontils9312213pontils
pontine92419053pontine
pontons93315553pontons
poplins11313153poplins
porting103021783porting
portions10514413portions
posties93128813posties
postin83521033postin_
posting105622243posting
postings112912303postings
potions93417423p_otions
potties93723543potties
potting103720893potting
poutine93316823poutine
poutines102415103poutines
pouting103519943pouting
prating103424453prating
proteins102114283proteins
protons93118003protons
prying124114803pry_ing
pterins9812993pterins
ptyalins1364693ptyalins
puffins15278913puffins
punkins133111113punkins
punties94520783punties
punting103318443punting
purins83722653p_urins
purlins93415423purlins
putons83515153p_utons
putties94420023putties
putting103218573putting
pyin96823233p_y_in_
pylons113011243p_ylons
pyrans11411063p_yrans
pythons1537363p_ythons
pyxies18338293p_yxies
pyxis17458633p_yxi_s
rhyming1634043rhyming
rhythms1842553rhythms
rhyton12356113rhyton_
rutins63818393_rutins
satins64930483_satins
shins85131043sh__ins
shtiks13297833sh_tiks
shuting113212053shuting
shying134211843shy_ing
statins73719773statins
stotins73213873stotins
theins95015423th_eins
thins85826333th__ins
thymine1536643thymine
thymines1635613thymines
tins45251303___tins
whins114922333wh__ins
whitens13428733whitens
whities133113253whities
whiting143311303whiting
whitings15287063whitings
wyting13277243_wyting
yins75335123__y_ins
zayins18409713zay_ins
zeatins16311733zeatins

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272246.06322105.7
3Display Results2242240.0932408.6
 (SQL Overall)1786912246.54627297.7
 
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.