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

125 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
potamic1331085(None) 
apogamic1545012apogamic
botanic1159582botanic
polemic13311252polemic
potassic1244922potassic
protamin121210542protamin
protatic12314752protatic
totemic1137532totemic
agamic113110563_agamic
astatic9514193astatic
atavic11189293_atavic
ataxic15169203_ataxic
atomic104115603_atomic
azotemic2194863azotemic
boracic1338723boracic
botanica1295723botanica
ceramic1339823ceramic
comatic131816943comatic
comic114721813co__mic
cosmic12410343co_smic
dioramic1346763dioramic
domic104317243do__mic
dynamic1545813dynamic
ectatic11310123ectatic
epitaxic1944283epitaxic
epitomic1446783epitomic
eponymic1745283eponymic
etamin81311853_etamin
exogamic2044083exogamic
formic13310453fo_rmic
gamic103916203__gamic
gonadic1177213gonadic
gothic1237793got_hic
holmic1338783ho_lmic
isthmic1444793isthmic
italic839903_italic
keramic1537233keramic
lotic76420673lot__ic
monadic1268883monadic
mosaic10311143mosa_ic
motific1446323motific
motivic1445163motivic
motoric11312233motoric
nomadic1248033nomadic
octadic1245713octadic
oghamic1544043oghamic
ohmic1237833_o_hmic
optic93715183opt__ic
osmic939913_o_smic
otalgic1045063_otalgic
otic66624823_ot__ic
otitic83112683_otitic
oxalic1537093_oxalic
panic93923903p__anic
panoramic1545283panoramic
patagia1068783patagia
patamar1147093patamar
pelagic1237863pelagic
pentomic1448143pentomic
phasic133612053p_hasic
phatic133014413p_hatic
phonemic1747173phonemic
photic133316443phot__ic
photonic15312103photonic
photopic17411093photopic
phthalic1855573phthalic
pianic103714123p_ianic
piratic11314293piratic
plasmic13249113plasmic
podagric1443543podagric
poditic122611583poditic
poetic10416843po_etic
polemics1448183polemics
politic112918713politic
polygamic1945083polygamic
pommie123710503po_mmie
pontific1545563pontific
postatomic1653933postatomic
potable112115363potable
potage92715903pota_ge
potages102416423potages
potash1138273pota_sh
potation101716783potation
potato8513433pota_to
potboil1195463potboil
potman102813573pot_man
potmen102713093pot_men
potpie103412433pot_pie
potsie83916033pot_sie
priapic1346023priapic
prolamin12139753prolamin
prosaic11311163prosa_ic
prostatic13410853prostatic
protamine131310913protamine
protamins131410773protamins
protasis102411973protasis
proteomic1546743proteomic
protonic12314593protonic
proxemic2146153proxemic
psalmic1345333psalmic
psoatic1139303psoatic
ptomain1146963ptomain
ptotic102713373p_totic
puranic11410483puranic
putamen1135923putamen
putamina1244543putamina
pyaemic1645873pyaemic
pyemic1537893p_yemic
pyramid1547513pyramid
satanic939933satanic
somatic111916473somatic
sporadic1345053sporadic
static83118683_static
tamis76728733__tamis
tatami839193tatami_
tatamis939723tatamis
tetanic9810133tetanic
titanic968553titanic
tonemic11310173tonemic
toxaemic1943563toxaemic
toxemic1845593toxemic
vitamin1237423vitamin
vocalic1446943vocalic
voltaic1245453volta_ic
zootomic2145423zootomic

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 Limit1340271256.92319359.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.37524229.3
 
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.