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

151 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
procaine1231227(None) 
procaines13311521procaines
cocaine111315172_cocaine
croceine1248032croceine
crocine11314152croc_ine
phocine1438832phoc_ine
porcine11312842porc_ine
prochain1548482prochain_
profane122111862profa_ne
prolamine131510562prolamine
proline92321592pro_line
promine112819442pro_mine
propane112716152propa_ne
propine113020212pro_pine
protamine131310912protamine
ptomaine1245532ptomaine
romaine9512122_romaine
apocrine1246933apocrine
arcane81216743ar_ca_ne
archine125817053ar_chine
arcsine94512393ar_csine
brocade1238533broca_de
brocading1556253brocading
bromine112915243bro_mine
brucine1138273bruc_ine
cocain101315013_cocain_
cocaines121314443_cocaines
cocains111313923_cocains
crocein1138073crocein_
croceines1347733croceines
croceins1238103croceins
crocking174313443crocking
crocoite1248053crocoite
domaine10610503_domaine
eucaine939243_eucaine
exocrine1745993exocrine
frocking18309573frocking
ibogaine1143713ibogaine
isocline1047293isocline
lidocaine1243093lidocaine
marocain1247063marocain_
marocains1346353marocains
merocrine1346233merocrine
moraine9314573_moraine
novocaine1442803novocaine
paracrine1348723paracrine
percaline13410953percaline
picoline12310853picoline
piscine11610973pisc_ine
plotline1037643plotline
pocking163916763p_ocking
pontine92419053p_ontine
pooching16328983pooching
porcini1137633porc_ini
porcino1138113porc_ino
porcupine1543273porcupine
potline91015233p_otline
poutine93316823p_outine
practice1438733practice
practise12310143practise
praise84419413pr__aise
praline93019743pr_aline
precative16312573precative
precavae1544813precavae
precipe133012123prec_ipe
precise113518173prec_ise
pricing123417343pric_ing
pricking173212603pricking
primine113214823pr_imine
pristine10313503pristine
proactive1648363proactive
probable1439053probable
proband122710243proba_nd
probang12278383proba_ng
probate11414483proba_te
probating14311193probating
probative1649173probative
probing123314443pro_bing
procarp1346823proca_rp
procarps1445973procarps
prochein1547523prochein_
prochoice1845153prochoice
proclaim1446073proclai_m
proclaimed1743253proclaimed
proclaimer1653063proclaimer
proclaims1545073proclaims
proclises1339543proclises
procure1138573proc_ure
procuring1437993procuring
prodding13189343prodding
profaned14207973profa_ned
profaner13197943profa_ner
profanes132311573profa_nes
profaning1537293profaning
profile123211153pro_file
progging132610383progging
prolamin12139753prolamin_
prolamines14159363prolamines
prolamins13159703prolamins
prolan8414693prola_n_
prolans9314273prola_ns
prolapse12134913prolapse
prolate9419793prola_te
prolines102619693pro_lines
promines123018803pro_mines
promise113415843pro_mise
promoing13310463promoing
pronate9418873prona_te
pronating12313763pronating
prone75332623pro___ne
pronging123511843pronging
proofing1439313proofing
propanes122415823propa_nes
propene112716043pro_pene
propined133111503pro_pined
propines122618933pro_pines
propone112716303pro_pone
propping122811673propping
prorate9418733prora_te
prorating12314283prorating
prosaic11311163prosai_c
prosaism1268043prosaism
prosaist10611583prosaist
proscribe1585623proscribe
prosing103319383pro_sing
prossie91812953prossi_e
prostie91617743prosti_e
protamin121210543protamin_
protamines14149803protamines
protamins131410773protamins
proteide11239723proteide
protein92414733protein_
proteins102114283proteins
provable1539093provable
provide1339853pro_vide
province1546923pro_vince
proving134214073pro_ving
prowling1449993prowling
ptomain1146963ptomain_
ptomaines1345533ptomaines
ptomains1246053ptomains
pyronine1349513pyro_nine
recane83022873_reca_ne
recline94020493_recline
rocaille1045383_rocaille
rocking143619633_rocking
romaines10512523_romaines
routine72615903_routine
trocking153612423trocking
tropine93116653tro_pine
trotline8310023trotline

Search took 7 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.423422437.4
2DLD Change Limit1461621516.37322934.6
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.85926052.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.