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

193 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
porcino113811(None) 
porcine11312841porcine
porcini1137631porcini
forcing134013752forcing
orcin72716572_orcin_
orcinol944702_orcinol
orcins83313432_orcins
poncing122913582poncing
porcinis1246952porcinis
poring94227272por_ing
porking143515812porking
porno75120652por__no
portico11310142portico
porting103021782porting
portion9615492portion
sordino8219442sordino
amorino9310253amor_ino
apocrine1246933apocrine
arcing95819643_arcing
arsino64113513_arsino
boring94724873bor_ing
borking144716173borking
coercing1349003coercing
coercion1246573coercion
corbina111911453corbina
cording113620823cording
coring94433963cor_ing
corking143018823corking
corning103720123corning
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
corvina12229503corvina
corvine122113643corvine
crocine11314153crocine
domino92611493do_mino
dormin9312313dormin_
dormins10311273dormins
farcing133514003farcing
fording123717043fording
forging124114723forging
forint9325023for_int
forking154014843forking
forming133615733forming
gorging102611363gorging
goring84119573gor_ing
gorming112810833gorming
hircine1239143hircine
hording123517053hording
horning113015003horning
hornito1047073hornito
horsing113215583horsing
lording93115233lording
merino8315093mer_ino
moraine9314573moraine
morion86217733mor_ion
morning103215043morning
morrion959003morrion
orbing93312363_orbing
orcein838183_orcein_
orceins937743_orceins
orcinols1044413_orcinols
orpin73415533_orpin_
orpine83914483_orpine
orpins83614163_orpins
oscine8311563_oscine
pacing114522753p_acing
panino8315683p_anino
parching164313053parching
pardine103616723pardine
parging113318603parging
paring94236493par_ing
parking143423043parking
parling103823763parling
parring103222063parring
parsing103819553parsing
parting103527383parting
peacing124117073peacing
pecorino1246633pecor_ino
pepino10310333p_epino
percent113520603percent
perching163711633perching
pereion9312053pereion
perking143716463perking
perming123416093perming
pernio8513143perni_o
phocine1438833phocine
piecing12410453piecing
piercing1346663piercing
piscina1177043piscina
piscine11610973piscine
placing123815283placing
poaching163510833poaching
poblano1145093poblano
pocking163916763pocking
poco86826153po_c__o
podding124113183podding
poind84217913po__ind
point75338733po__int
poising103617103poising
poking133819303po_king
policing13311673policing
poling93526503po_ling
polio75722553po_li_o
polling102920383polling
pompano1345203pompano
poncho133310123ponc_ho
ponding114317083ponding
ponging113416153ponging
pontine92419053pontine
ponying133312123ponying
pooching16328983pooching
poohing133112323poohing
pooing93820683po_oing
pooling103219093pooling
pooping123615443pooping
poplin10413483poplin_
poplins11313153poplins
popping113715413popping
porch125918623porc__h
porches143815673porches
porcupine1543273porcupine
porgies103017003porgies
porism104518063por_ism
porkier133712343porkier
porkies133416493porkies
porn65636023por__n_
pornier93413133pornier
pornos85015253por__nos
porns75527343por__ns
porny106020193por__ny
portend103411193portend
portent93619643portent
porticos1238373porticos
portions10514413portions
posing93922643po_sing
postin83521033postin_
posting105622243posting
postins93721203postins
potion84519573po_tion
potline91015233potline
potting103720893potting
pouching163210413pouching
pouncing13318883pouncing
pouring103115863pouring
poutine93316823poutine
pouting103519943pouting
poxing163714943po_xing
pricing123417343pricing
primo95017913p_r_imo
prink114719673p_r_ink
print74837463p_r_int
prion75119993p_r_ion
probing123314443probing
procaine12312273procaine
proline92321593proline
promine112819443promine
propine113020213propine
prosing103319383prosing
proving134214073proving
proviso1237313proviso
proximo1845143proximo
prying124114803p_rying
purging113314183purging
purin75527593pur_in_
purine85321893pur_ine
purins83722653pur_ins
purlin83615863purlin_
purline93516533purline
purling103620293purling
purlins93415423purlins
purring104515823purring
pursing103715553pursing
rhino84614323__rhino
sarcina9310733sarcina
sorbing102815263sorbing
sordine82515233sordine
sordini8228963sordini
soricine10710883soricine
soring74731883sor_ing
sorning83116813sorning
sorting83221813sorting
sourcing1158353sourcing
sporing104319413spor_ing
sporting112415463sporting
torching142510083torching
torchon1237363torchon
torsion7310803torsion
voicing13279083voicing
volcano1244613volcano
wording123014563wording
working153813253working
worming132811243worming

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.1531167915.0
2DLD Change Limit1340271937.33018284.7
3Display Results1931930.0633063.5
 (SQL Overall)1786911937.54623680.2
 
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.