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

382 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
porcine1131284(None) 
porcini1137631porcini
porcino1138111porcino
apocrine1246932apocrine
corvine122113642corvine
crocine11314152crocine
forcing134013752forcing
hircine1239142hircine
moraine9314572moraine
orcin72716572_orcin_
orcins83313432_orcins
orpine83914482_orpine
oscine8311562_oscine
pardine103616722pardine
phocine1438832phocine
piscine11610972piscine
poncing122913582poncing
pontine92419052pontine
porcinis1246952porcinis
porcupine1543272porcupine
poring94227272por_ing
porking143515812porking
porting103021782porting
potline91015232potline
poutine93316822poutine
procaine12312272procaine
proline92321592proline
promine112819442promine
propine113020212propine
purine85321892pur_ine
purline93516532purline
sordine82515232sordine
soricine10710882soricine
airline7315033airline
arcane81216743_arcane
archine125817053_archine
arcing95819643_arcing
arcsine94512393_arcsine
arsine64021043_arsine
berline93716853berline
boccie123311453bocci_e
boracite1249193boracite
borane84620213bor_ane
boride9415903bor_ide
boring94724873bor_ing
borking144716173borking
borne77926793bor__ne
bornite9311183bornite
bovine11712433bo_vine
bowline123613113bowline
brine75132273_br_ine
bromine112915243bromine
brucine1138273brucine
calcine11315273calcine
carbine112918643carbine
carline93923613carline
carmine112918483carmine
cervine122610803cervine
chorine123218363chor_ine
cine66242943___cine
cocaine111315173cocaine
codeine103815033codeine
coercing1349003coercing
coercive1545873coercive
colicine12312993colicine
combine133014723combine
concise11314473concise
confine12315583confine
coniine9316803coniine
conine84528553co_nine
corbie103618203corbi_e
corbina111911453corbina
cording113620823cording
cordite10315263cordite
coring94433963cor_ing
corking143018823corking
cornice11612933cornice
corning103720123corning
corrie83621223corri_e
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
corvina12229503corvina
cosine83823513co_sine
croceine1248033croceine
docile94213123do_cile
domaine10610503domaine
domine92918253do_mine
dormice1237133dormice
dormie9312623dormi_e
dormin9312313dormin_
dormins10311273dormins
dourine8311453dourine
eccrine1137283eccrine
eocene8311613eo_cene
eosine64519413eo_sine
ermine8416923_ermine
errhine1036593errhine
exocrine1745993exocrine
exorcise1745933exorcise
exorcize2644893exorcize
farcie114816473farci_e
farcing133514003farcing
fascine12510583fascine
ferine96422583fer_ine
force105324273forc__e
forcible1545143forcible
forcipes1535943forcipes
fording123717043fording
fordone1149383fordone
forging124114723forging
forgive1436193forgive
forgone1139343forgone
forint9325023for_int
forking154014843forking
forming133615733forming
fortune1068303fortune
glycine1335713glycine
gorging102611363gorging
goring84119573gor_ing
gorming112810833gorming
harmine122816193harmine
heroine103517483heroine
hording123517053hording
hormone12410503hormone
horning113015003horning
horsing113215583horsing
hotline10712353hotline
hyoscine1644183hyoscine
iodine74618653io_dine
koine9516483ko__ine
larine63927043lar_ine
leporine1049303lepor_ine
leucine938073leucine
lording93115233lording
loricae938253loricae
loriner7511893lor_iner
marine84230403mar_ine
marline93320953marline
moline84422033mo_line
moraines10314363moraines
morning103215043morning
morphine1548703morphine
mortice11711493mortice
mortise9713533mortise
murine84220023mur_ine
murrine9411483murrine
narceine1046753narceine
nardine82712573nardine
narine63422553nar_ine
nervine102510623nervine
norite63221133nor_ite
oleine6313793_oleine
online6315843_online
oorie53026363oor_i_e
opaline9412483opaline
opine77422463_o_pine
orbing93312363_orbing
orcein838183_orcein_
orceins937743_orceins
orcinol944703_orcinol
ordines83014903_ordines
oreide7311673_oreide
orgone71110913_orgone
oroide7311703_oroide
orpin73415533_orpin_
orpines94414793_orpines
orpins83614163_orpins
orrice81410163_orrice
oscines9310363_oscines
ovine86316643_o_vine
pacing114522753p_acing
paracrine1348723paracrine
parcener1238473parcener
parching164313053parching
pardie96021443pardi_e
parging113318603parging
paring94236493par_ing
parking143423043parking
parling103823763parling
parring103222063parring
parsing103819553parsing
parting103527383parting
partite9317133partite
parvise124211693parvise
patine85328123p_atine
peacing124117073peacing
pennine93712953pennine
pepsine11310603pepsine
percale11314093percale
percaline13410953percaline
perceive1546973perceive
percent113520603percent
perching163711633perching
perdie94718513perdi_e
perinea9313033per_inea
perking143716463perking
perlite9317313perlite
perming123416093perming
picrite111911313picrite
piecing12410453piecing
piercing1346663piercing
pine67755713p___ine
piscina1177043piscina
piscinae1285213piscinae
placing123815283placing
plotline1037643plotline
poaching163510833poaching
pocking163916763pocking
podding124113183podding
podite93315353po_dite
podlike14108553podlike
poetise9314043poetise
poetize18310773poetize
poind84217913po__ind
point75338733po__int
pointe84619313po__inte
poise75127893po__ise
poising103617103poising
poking133819303po_king
police102918563po_lice
policing13311673policing
poling93526503po_ling
polite83625073po_lite
polling102920383polling
polyene1259363polyene
pommie123710503pommi_e
ponce95222513ponc__e
ponding114317083ponding
pone65747533po___ne
ponging113416153ponging
ponying133312123ponying
pooching16328983pooching
poohing133112323poohing
pooing93820683po_oing
pooling103219093pooling
pooping123615443pooping
poplin10413483poplin_
poplins11313153poplins
popping113715413popping
popsie103013053popsi_e
porch125918623porc__h
porches143815673porches
porcupines1642823porcupines
pore66451263por___e
porgies103017003porgies
porism104518063por_ism
porkier133712343porkier
porkies133416493porkies
porkiness15249193porkiness
porkpie1544673porkpie
porn65636023por__n_
pornier93413133pornier
porno75120653por__no
porns75527343por__ns
porny106020193por__ny
porose84818743por_ose
porpoise1248083porpoise
porridge1243763porridge
porringer1244053porringer
portage103013643portage
portance12310113portance
portend103411193portend
portent93619643portent
portico11310143portico
portiere1038773portiere
portion9615493portion
portioned1248333portioned
portioner1158683portioner
portions10514413portions
portside1138163portside
posing93922643po_sing
postie84123963posti_e
postin83521033postin_
posting105622243posting
postins93721203postins
potiche1438043potiche
potlike13910123potlike
potlines10714213potlines
potpie103412433potpi_e
potsie83916033potsi_e
potting103720893potting
pouching163210413pouching
pouncing13318883pouncing
pouring103115863pouring
poutines102415103poutines
pouting103519943pouting
poxing163714943po_xing
praise84419413p_raise
praline93019743praline
precipe133012123precipe
precise113518173precise
price93725413p_r_ice
pricing123417343pricing
pride84724733p_r_ide
prime96525603p_r_ime
primine113214823primine
prince104114763p_r_ince
prink114719673p_r_ink
print74837463p_r_int
prise74632613p_r_ise
prize164718943p_r_ize
probing123314443probing
procaines13311523procaines
procure1138573procure
profane122111863profane
profile123211153profile
prolines102619693prolines
promines123018803promines
promise113415843promise
prone75332623p_r_one
propane112716153propane
propene112716043propene
propined133111503propined
propines122618933propines
propone112716303propone
prosing103319383prosing
provide1339853provide
province1546923province
proving134214073proving
prune75119633p_r_une
prying124114803p_rying
ptomaine1245533ptomaine
purging113314183purging
purin75527593pur_in_
purines94420763pur_ines
purins83722653pur_ins
purlin83615863purlin_
purlines103514053purlines
purling103620293purling
purlins93415423purlins
purring104515823purring
pursing103715553pursing
pyrene113210733pyr_ene
pyridine1447743pyridine
pyrite11913313pyr_ite
pyrone112714473pyr_one
pyronine1349513pyronine
quercine1964863quercine
romaine9512123romaine
routine72615903routine
sarcina9310733sarcina
sarcinae1047193sarcinae
sardine83317393sardine
serine65432673ser_ine
shrine94920053shr_ine
sorbing102815263sorbing
sordines92414073sordines
sordini8228963sordini
sordino8219443sordino
soring74731883sor_ing
sorning83116813sorning
sortie63621993sorti_e
sorting83221813sorting
sourcing1158353sourcing
sourdine936893sourdine
sozine15712353so_zine
spermine12311433spermine
sporicide1484793sporicide
sporing104319413spor_ing
sporting112415463sporting
sportive1348333sportive
tacrine9311293tacrine
terrine72517573terrine
tontine72316143tontine
topline92313183topline
torching142510083torching
tortile7313193tortile
towline102911543towline
toxine133114123to_xine
trine54734603_tr_ine
tropine93116653tropine
turbine9310303turbine
turdine8310283turdine
urine55026593_ur_ine
ursine64114123_ursine
vaccine1437323vaccine
versine102515173versine
voicing13279083voicing
wording123014563wording
working153813253working
worming132811243worming

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273826.06322105.7
3Display Results3823820.1263031.7
 (SQL Overall)1786913826.34228175.8
 
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.