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

124 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
protatic1231474(None) 
prostatic13410851prostatic
aromatic12315632aromatic
parotitic1349332parotitic
potamic13310852p_otamic
prelatic12311282prelatic
prosaic11311162prosa_ic
protamin121210542protamin
protasis102411972protasis
prothetic161010072prothetic
protistic13410982protistic
protonic12314592protonic
psoatic1139302pso_atic
acrobatic1587733acrobatic
aerobatic1399003aerobatic
aprotic112715243apro__tic
aromatics13410893aromatics
astatic9514193_astatic
biotitic1247573biotitic
botanic1159583_botanic
chromatic18412333chromatic
comatic131816933_comatic
cryostatic1753803cryostatic
dramatic1369423dramatic
ecstatic1246153ecstatic
ectatic11310123_ectatic
epistatic1346103epistatic
erotic82620273ero__tic
erratic9311113er_ratic
eustatic1047343eustatic
geotactic1444083geotactic
glottic1036653glot_tic
isostatic1145353isostatic
isotactic1344243isotactic
otitic83112683__otitic
paratactic1684633paratactic
parotic112518043paro__tic
parotitis1149173parotitis
phatic133014413p__hatic
phonetic15310323phonetic
photic133316443pho__tic
photonic15312103photonic
photopic17411093photopic
phreatic1548343phreatic
piratic11314293p_iratic
poditic122611583p_oditic
poetic10416843p_o_etic
politic112918713p_olitic
portative1449373portative
potassic1244923p_otassic
potation101716783p_otation
potato8513433p_otat_o
practic13312243pr_actic
pragmatic1647633pragmatic
priapic1346023pr_iapic
prismatic1547163prismatic
probate11414483probat_e
probated13410863probated
probates12414283probates
probating14311193probating
probation13412183probation
probative1649173probative
probiotic1546663probiotic
proclitic1548113proclitic
proctitis1348363proctitis
prolactin1347773prolactin
prolamin12139753prolamin
prolate9419793prolat_e
proleptic1547113proleptic
prolific1546743prolific
prometric15410643prometric
pronate9418873pronat_e
pronated11414053pronated
pronates10418373pronates
pronating12313763pronating
pronation11415703pronation
pronator10311783pronator
prophasic1848473prophasic
prophetic18710583prophetic
propylic1747183propylic
prorate9418733prorat_e
prorated11513713prorated
prorates10418073prorates
prorating12314283prorating
proration11415983proration
prosodic1347693prosodic
prostate10314533prostat_e
prostates11314423prostates
prostatism1447743prostatism
prosthetic1797353prosthetic
prostie91617743pro_stie
protamine131310913protamine
protamins131410773protamins
protases102115033protases
protei82615313prot_ei_
proteid103513673prot_eid
protein92414733prot_ein
proteinic1346883proteinic
proteomic1546743proteomic
protopathic2054543protopathic
prototypic1954773prototypic
protoxid1849143protoxid
protozoic2246153protozoic
protreptic1644723protreptic
proxemic2146153proxemic
pruritic1267403pruritic
psoriatic1387023psoriatic
ptotic102713373p__totic
puritanic1343583puritanic
pyrolytic1957053pyrolytic
robotic1139223_robotic
romantic1249233_romantic
rotate63320343_rotat_e
rotated82715293_rotated
rotates72819773_rotates
rotating92614553_rotating
rotation81615453_rotation
rotative11310343_rotative
rotator7310833_rotator
somatic111916463_somatic
static83118683__static
stomatic12311993stomatic
stromatic13410203stromatic
uratic83016353ur__atic

Search took 9 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.420425454.8
2DLD Change Limit1461621247.56319325.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.02922255.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.