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

156 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
physic1628847(None) 
phasic133612051phasic
phylic16279551phylic
physics17265961physics
physis14359661physis
aphasic142810062aphasic
chymic18317882chymic
phasis114614922phasis
phatic133014402phatic
phobic153010062phobic
phonic133315202phonic
photic133316422photic
physed15386792physed
physes14399782physes
physical1845702physical
phytin14459002phytin
pyic116915822p_y_ic
pyric123815072p_yric
thymic16307412thymic
amylic13108703amylic
anisic8313793anisic
aphasia122510873aphasia
aphasiac15286593aphasiac
aphasics15257233aphasics
aphesis12610513aphesis
aphetic142912853aphetic
aphonic142713393aphonic
aphotic142913113aphotic
atypic13337653atypic
basic96220523_basic
beylic1337823beylic
biphasic1744183biphasic
chasmic16177983chasmic
chemic153012093chemic
chic115925203ch__ic
choric133515893choric
chymics19295533chymics
crisic103611843crisic
cynic124712423_cynic
cystic132710653_cystic
diphasic1645803diphasic
ecesic10369223ecesic
ephebic1646513ephebic
ethylic1546323ethylic
felsic1147053felsic
hemic125718623_hemic
hic86540563_h__ic
huic94818053_h_uic
humic124113243_humic
hydric15227953_hydric
hyenic1438723_hyenic
hyoid12612423_hyoid
hypnic1637263_hypnic
hyson1138693_hyson
lyric104512723_lyric
lysin84512783_lysin
lysis84511463_lysis
lytic104513033_lytic
mesic93617863_mesic
music94316403_music
mysid11610683_mysid
mystic132711643_mystic
ohmic1237833oh_mic
oophytic1865953oophytic
ophitic1439213ophitic
panic93923903p_anic
parsec105914483parsec
passim10410283passim
paynim1337363paynim
pays95940223pays__
pectic122913873pectic
pelvic13307553pelvic
pensil83013333pensil
pepsin10310853pepsin
peptic122113153peptic
phallic1447293phallic
phase104617213phas_e
phased124011973phased
phases114618403phases
phasing133211673phasing
phasmid15267603phasmid
phenix1837133phenix
phenylic1844473phenylic
phi86524203ph__i_
phis95724903ph__is
phiz186718843ph__iz
phobia13278593phobia
phobics16286703phobics
phonics143110723phonics
photics142810473photics
phrenic1438773phrenic
phthisic1853903phthisic
phyla13469183phy_la
phylae14458733phylae
phylar14437373phylar
phyle134111153phy_le
phylesis1645303phylesis
phyletic1847213phyletic
phyllo1435873phyllo
phylon14318033phylon
phylum1655153phylum
physeds16344033physeds
physicals1943693physicals
physician1953893physician
physicist1955183physicist
physicked2442113physicked
physique2551663physique
phytins15317893phytins
phytoid1678733phytoid
phytol14366563phytol
phyton143610253phyton
phytonic1848193phytonic
pianic103714123pianic
pic76046823p___ic
picnic123410263picnic
picric12309923picric
pionic103515953pionic
plasmic13249113plasmic
plastic112815063plastic
poetic10416843poetic
popsie103013053popsie
posit75833333p_osit
potsie83916023potsie
prosaic11311163prosaic
prosit85124593prosit
prussic1144743prussic
psi56621623p__si_
psis68120343p__sis
psychic1944833psychic
ptosis83611823ptosis
ptotic102713363ptotic
pubic114513723p_ubic
public12238143public
pudic104614563p_udic
pyemic1537893pyemic
pyin96823233p_y_in
pyknic1734893pyknic
pyoid11513753p_yoid
pyosis114012123pyosis
pyxie17359363p_yxie
pyxis17458633p_yxis
rhodic12227223rhodic
rhotic112711213rhotic
sic55847873___sic
sphenic1449093sphenic
spheric14510073spheric
sphygmic2141973sphygmic
thesis94913733thesis
thetic11412883thetic
thoric114314033thoric
thymi13418623thymi_
thyrsi1234453thyrsi_
typic124511963_typic
whosis1237163whosis
whys137011663whys__
zoysia1844163zoysia

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 Limit1127161565.70319764.3
3Display Results1561560.0463391.3
 (SQL Overall)1786911565.88930343.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.