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

102 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
phonetic1531032(None) 
phenetic1549201phenetic
phonemic1747171phonemic
phonetics1646731phonetics
phenetics1646482phenetics
phonematic1945442phonematic
phonemics1844932phonemics
phonetist1448812phonetist
phonic133315212phon__ic
photic133316442pho__tic
phrenetic1645922phrenetic
phyletic1847212phyletic
poetic10416842p_o_etic
tonetic9313432_tonetic
aconitic1239533aconitic
agenetic1138203agenetic
akinetic1455953akinetic
aloetic9313183alo_etic
anoretic10312933anoretic
aphanitic1646013aphanitic
apheretic1687413apheretic
aphetic142912853aph__etic
aphonic142713393aphon__ic
aphotic142913123apho__tic
biontic1148333bion_tic
choleric15107913choleric
choreatic1647713choreatic
choreic1438703chore_ic
cometic131215723_cometic
deontic1038883deon_tic
docetic1239913_docetic
frenetic1346293frenetic
genetic101211783_genetic
geodetic1246323geodetic
hebetic1438633_hebetic
heretic12314833_heretic
homeotic1548283_homeotic
homeric14312213_homeric
kinetic13209173_kinetic
limnetic1255583limnetic
magnetic1349233magnetic
noetic8514043_no_etic
nonphonetic1864403nonphonetic
ontic74418573__on_tic
panoptic1447183panoptic
paretic113016673p_aretic
pathetic15410963pathetic
phatic133014413ph__atic
phenetol1344063phenetol
phenolic1546813phenolic
phenylic1844483phenylic
phimotic1747153phimotic
phobic153010073pho__bic
phoenix1944363pho_enix
phonate12411813phonat_e
phonated1447893phonated
phonates13410643phonates
phonating1537813phonating
phonation1439393phonation
phone105621933phone___
phoned124014553phone__d
phoneme1446203phone_me
phonemes1546193phonemes
phones114121213phone__s
phonetician1853883phonetician
phonetists1545413phonetists
phoney143612983phone__y
phoneyed1743843phoneyed
phoneying1844283phoneying
phoneys15437143phone_ys
phonics143110723phon__ics
photics142810483pho__tics
photonic15312103photonic
photopic17411093photopic
phreatic1548343phreatic
phrenic1438773ph_renic
phyletics1944583phyletics
pionic103515953pion__ic
poditic122611583p_oditic
poetics11312073p_o_etics
polemic13311253p_olemic
politic112918713p_olitic
pontil8315463p_on_til
proleptic1547113proleptic
prometric15410643prometric
prophetic18710583prophetic
protatic12314743protatic
prothetic161010073prothetic
proxemic2146153proxemic
psoatic1139303pso_atic
ptotic102713373pto__tic
pycnotic1745823pycnotic
pyknotic1944203pyknotic
pyogenic1648583pyogenic
pyretic143210783p_yretic
rhotic112711233rho__tic
splenetic1345073splenetic
theoretic1446663theoretic
thetic11412893th__etic
tonemic11310173_tonemic
tonetics1048943_tonetics
zoonotic1945323zoonotic

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621026.92321112.5
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.35924282.0
 
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.