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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
physics1726596(None) 
physic16288471physic_
physis14359661physi_s
aphasics15257242aphasics
chymics19295532chymics
phasic133612052phasic_
phasis114614922phasi_s
phobics16286702phobics
phonics143110722phonics
photics142810482photics
phylic16279552phylic_
physeds16344032physeds
physes14399782phys_es
physical1845702physical
physicals1943692physicals
physicist1955182physicist
phytins15317892phytins
aphasiacs16254223aphasiacs
aphasias132710443aphasias
aphasic142810063aphasic_
aphesis12610513aphesi_s
aphonics15259523aphonics
basics104915123_basics
beylics1436183beylics
biophysics2253493biophysics
chemics16349583chemics
chics123920943ch__ics
chymic18317883chymic_
cynics13377363_cynics
geophysics2153483geophysics
hyoids1377673_hyoids
hysons1237633_hysons
lyrics11357943_lyrics
lysins94610953_lysins
lysis84511463_lysi_s
musics103911783_musics
mysids1246563_mysids
mystics14279103_mystics
palsies94420273palsies
panics103815363p_anics
pansies94521983pansies
parsecs11429923parsecs
patsies93919483patsies
paynims1434973paynims
pelvics14245643pelvics
pensils92811593pensils
pepsins11310433pepsins
peptics132610243peptics
phases114618403phas_es
phasing133211673phasing
phasmids16195183phasmids
phatic133014413phatic_
phis95724903ph__i_s
phobias14228183phobias
phobic153010073phobic_
phonic133315213phonic_
phonies123717513phonies
photic133316443photic_
phthisics1962443phthisics
phylesis1645313phylesi_s
phyletics1944583phyletics
phyllos1535583phyllos
physed15386793phys_ed
physician1953893physician
physicians2053283physicians
physicists2053923physicists
physicked2442113physicked
physique2551663physique
physiques2641703physiques
phytin14459013phyti_n
phytols15276553phytols
phytons15319063phytons
picnics13297343picnics
pics85633913p___ics
plastics122412333plastics
poesies93217403poesies
poetics11312073poetics
popsies112816463popsies
posies84431433p_osies
posits85718713p_osits
potsies93019483potsies
psis68120343p__si_s
psychics2043823psychics
ptosis83611823ptosi_s
publics13207143publics
pussies93615693pussies
pyic116915823p_y_ic_
pyins105815863p_y_ins
pyknics1842483pyknics
pyosis114012123pyosi_s
pyric123815073p_yric_
pyxies18338293p_yxies
pyxis17458633p_yxi_s
sics65234093___sics
spherics1537073spherics
thesis94913733thesi_s
thymic16307423thymic_
whosis1237173whosi_s
zoysias1943843zoysias

Search took 8 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.406440125.6
2DLD Change Limit134027996.61020276.4
3Display Results99990.0303300.0
 (SQL Overall)178691997.04625360.6
 
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.